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

SSIS cannot be run on SQL 2000. And you can't port SSIS to SQL 2000 as a DTC package.