SQL Server Performance Forum – Threads Archive

DTC in SSIS

I am using SQL server 2000 as the source in loading the tables of the database in the SQL server 2005, this execution needs the parallel execution from the source. When I ran the package of SSIS containing the above task, it gives error like "Cannot enlist in the Distributed transaction". When I tried out the same task in the SQL serve 2005 it’s working correctly, the parallel execution doesn’t gives me the problem. I have assumed that problem is bcoz of DTC in SQL server 2000. Can anyone guide me?
Thanks in advance, Saravnan.W.S

Have you checked MSDTC server is started or not on SQL 2000 instance? Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided Ã¯Â¿Â½AS ISÃ¯Â¿Â½ with no rights for the sake of knowledge sharing.

Are You talking about the MSDTC service or server? how can i check the status? If that is going to be the service, I can check it from the Administrative Service console

It will be installed as a Service (MSDTC) and check from the location you’ve mentioned. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided Ã¯Â¿Â½AS ISÃ¯Â¿Â½ with no rights for the sake of knowledge sharing.

]]>