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
|