Tuesday, February 14, 2012

Distributed transaction completed. Either enlist this session in a new transaction or the NU

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

No comments:

Post a Comment