Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction.
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.
December 22nd, 2006 12:36pm
I have checked with MSDTC and timeout. timeout is 30. any other suggest . thanks Manoj Verma
December 22nd, 2006 5:01pm
Hi, Did you find a solution to your problem? I am having the exact same problem as you.
January 15th, 2008 6:26pm
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
January 15th, 2008 9:54pm
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.
April 4th, 2008 8:33am
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.
October 26th, 2009 7:02pm
Hi David See my above response to Manoj's problem.Regards,Gert
October 26th, 2009 7:03pm
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.”
May 18th, 2011 9:08am