i have a sequence container in my my sequence container i have a script task for drop the existing tables.This seq. container connected to another seq. container.all these are in for each loop container when i run the package it's work fine for 1st looop but it gives me error for second execution. Message is like this: Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction.

I have checked with MSDTC and timeout. timeout is 30. any other suggest . thanks Manoj Verma

Hi, Did you find a solution to your problem? I am having the exact same problem as you.

Hi David, Could you describe your package? Are you embedding multiple sequence containers in a for loop, like the original poster? Where is the "TransactionOption" being set? Thanks, ~Matt

This erro due a constraint failure on DB front; but has to do nothing with DTC. The fail rolls back the transaction and there by forces the connection instance to come out of transaction. thus the resultant error message!! Check for other error messages logged / part of the exception for more information.

Hi ManojI had the same errormessage when executing a trigger on table A on Server A which then reads data from Server B's table A.Both servers have SQL 2000 loaded but server A had SP4 and server B not.Loading SP4 on server B resolved the issue for me.Hope this helps.Regards,Gert.

Hi David See my above response to Manoj's problem.Regards,Gert

I have the db on a sql server 2000 with sp4. I still get this error in Ui when i try to do some update. Application and db is on single server. please help as this is urgent. Error message: “Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction.”