Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
damcalcan
Starting Member
11 Posts |
 Posted - 2002-03-31 : 09:43:03
|
| I’m using SQL Server 2000 Standard Edition SP 2.I have a DTS package that consists of an “Execute SQL Task”. I want the “Execute SQL Task” to be executed in the context of a transaction so I ‘ve checked the following properties from Workflow Properties Dialog Box Options Tab : “Join transaction if present”; “Commit transaction on successful completion of this step” and “Rollback transaction on failure” . The DTS is stored in the above mentioned server .Problem: When I execute the package from other machine than the one witch host the SQL Server I’ve got the following error : Error Source : “MS OLEDB Provider for SQL Server”Error Description : “Connection ‘SQL Server Conn’ for the task ‘DTS Task 1’ does not support joining distributed transaction or failed when attempted to join. New transaction cannot enlist in the specified transaction coordinator. ”I have MDAC 2.7 on the client machine and the MSDTC started both on client and server machine.When I execute the package from server machine everything works fine.Thanks for any advicecalin |
|
|
|
|
|
DTS Transaction Error