locked
Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction. RRS feed

  • Question

  • 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.

    Friday, December 22, 2006 9:36 AM

Answers

  • 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.

    Friday, April 4, 2008 5:33 AM

All replies

  • I have checked with MSDTC and timeout.

    timeout is 30.

    any other suggest .

    thanks

    Manoj Verma

    Friday, December 22, 2006 2:01 PM
  • Hi,  Did you find a solution to your problem?  I am having the exact same problem as you.

     

    Tuesday, January 15, 2008 3:26 PM
  • 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

     

    Tuesday, January 15, 2008 6:54 PM
  • 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.

    Friday, April 4, 2008 5:33 AM
  • Hi Manoj

    I had the same error message 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.
    Monday, October 26, 2009 4:02 PM
  • Hi David

    See my above response to Manoj's problem.

    Regards,
    Gert
    Monday, October 26, 2009 4:03 PM
  • 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.”

     

    Wednesday, May 18, 2011 8:50 AM