Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS package: unable to enlist in the transaction Expand / Collapse
Author
Message
Posted Tuesday, May 26, 2009 6:00 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, May 28, 2012 4:06 AM
Points: 11, Visits: 69
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
Post #723190
Posted Tuesday, May 26, 2009 11:23 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, May 28, 2012 4:06 AM
Points: 11, Visits: 69
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
Post #723788
Posted Tuesday, April 22, 2014 12:40 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, June 23, 2014 6:03 AM
Points: 920, Visits: 702
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
Post #1563695
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse