May 26, 2009 at 6:00 am
Hi,
I have SSIS package where the property of package for TransactionOption is set to “Required”.
This package when I am executing from the SQL 2005 server (the same machine where the SQL server 2005 is installed), then it’s working fine and the transaction is also working successfully.
But the same package when I am executing from my PC, then its giving error message as follows:
[Connection manager "Plan CDDH-M3"] Error: The SSIS Runtime has failed to enlist the OLE DB connection in a distributed transaction with error 0x8004D00A "Unable to enlist in the transaction.".
Can any one help me in this?
Regards
Raj
May 26, 2009 at 11:23 pm
I got the answer.
Actually we need to set the property for MSDTC service, just go to Control panel -> component services click on property of "my computer" go to MSDTC tab then click on below all check boxes.
1. Network DTC Access
2. Allow Remote Client
3. Allow Remote Administrator
4. Allow Inbound
5. Allow Outbound
Now the SSIS package working perfectly
April 22, 2014 at 12:40 am
I am facing the same issue, but I am not able to see these option on my local machine's MSDTC.
Abhijit - http://abhijitmore.wordpress.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply