Post reply

DTC in SSIS

  • June 22, 2006 at 6:49 am

    #168707

    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 in SQL server 2005.

    I have assumed that problem is bcoz of DTC in SQL server 2000. Can anyone guide me? 

    Thanks in advance,

    Saravnan.W.S

     

  • June 27, 2006 at 5:55 am

    #646033

    Hi all,

            I have solved this problem by using the Sequence container. I have put all the Execute Package Tasks needs to be in the transaction to a sequence container. I have set the TransactionOption Property to Required for the sequence container and for all the child Execute Package Tasks I set as Supported, this made the Packages to enlist in the transaction.

     

    Thanks,

    Saravanan.W.S

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply