April 26, 2009 at 10:53 pm
In one SSIS package, I m using sequence container with transaction option = required.
The sequence container contains the task which executes the stored procedure.
This SSIS works fine when I refer to SQL DB locally.
But if I point the package to remote DB (from other machine) then it gives me error.
The SSIS Runtime has failed to enlist the OLE DB connection in a distributed transaction with error 0x8004D025
If I change the Sequence container transaction property from Required to Supported then I am able to point the package to remote machine DB.
Please suggest how to make the package working with Required transaction option for Sequence container and point it to remote machine DB
thanks
April 26, 2009 at 11:34 pm
This thread might help you:
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
December 26, 2010 at 5:18 am
Please see this URL
http://the-it-articles.blogspot.com/2010/12/partner-transaction-manager-has.html
Varinder Sandhu,
http://www.varindersandhu.in/
December 26, 2010 at 7:32 am
Varinder Sandhu (12/26/2010)
http://the-it-articles.blogspot.com/2010/12/partner-transaction-manager-has.html%5B/quote%5D
So you ripped of a post on MSDN from a person who solved his own problem, so you could post it on your own blog, then go to a forum (this one) to post a link to your blog? While actually the problem in this thread has already been solved a year and a half ago by Phil posting an URL to the original MSDN forum post?
:rolleyes: (--> this smiley is rolling with his eyes. It isn't always very clear.)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 5, 2014 at 9:38 am
Hey guys, I followed the instructions but when I click the MSDTC tab I dont see a link for "Security Configuration". Am I doing something wrong?
August 5, 2014 at 10:23 am
I followed the steps in the following link and set the properties as seen on the page there. I'm still getting the "The partner transaction manager has disabled its support for remote/network transactions." error when running the package from my laptop. I have the same settings on my laptop. I also get an error when I run the package on the server from an SQL Job.
http://blog.arjanfraaij.com/2010/11/enabling-distributed-transaction.html
August 5, 2014 at 10:48 am
Ok, I went back and followed all of the instructions including enableing the DTC TCP rules for the firewall for both servers as well as my laptop and now getting the following error:
The transaction has already been implicitly or explicitly committed or aborted
September 17, 2015 at 10:33 am
The SSIS Runtime has failed to enlist the OLE DB connection in a distributed transaction with error 0x8004D025 “The partner transaction manager has disabled its support for remote/network transactions.”.
Solution: Click the dataflow task–>properties–> change the transaction option to “supported” this will solve the issue.
September 17, 2015 at 10:35 am
In case you missed it.
The SSIS Runtime has failed to enlist the OLE DB connection in a distributed transaction with error 0x8004D025 “The partner transaction manager has disabled its support for remote/network transactions.”.
Solution: Click the dataflow task–>properties–> change the transaction option to “supported” this will solve the issue.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply