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 |
|
ashley.sql
Constraint Violating Yak Guru
299 Posts |
 Posted - 2007-10-16 : 09:23:50
|
| I created several DTS packages. When I run them from server or schedule them as a job they run fine. But when I run them from clientI get this error:Connection 'MicroSoft OLEDB Provider For SQL Server' for Task 'DTSTask_DataDrivenQueryTask_1' does not suport joining distributed transactions or failed when attempting to join. Unable to Enlist in the Transaction. New Transaction cannot cannot enlist in the specified transaction coordinator. Any help on this. I have tried everything mentioned in this link and still nothing worked:http://support.microsoft.com/kb/839279I need to run the DTS from the client. If anyone knows of this and was able to solve it let me know. Thanks a lot.-----------------------------------------------------------------------------------------------Ashley Rhodes |
|
|
ashley.sql
Constraint Violating Yak Guru
299 Posts |
Posted - 2007-10-16 : 10:50:17
|
| The pakcage succeeds if I go to the package properties and Uncheck the Box which says USE TRANSACTIONS in the advanced tab.But I am not sure how will that that effect the DTS package. Does anyone knows how that works and if I can leave it unchecked.Thanks-----------------------------------------------------------------------------------------------Ashley Rhodes |
 |
|
|
|
|
|
DTS Fails when run from Client Succeeds in Server