Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
raj4582
Starting Member
16 Posts |
 Posted - 2009-05-26 : 07:53:49
|
| 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?RegardsRaj |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-05-26 : 11:57:11
|
| is MSDTC service configured in your machine? |
 |
|
|
raj4582
Starting Member
16 Posts |
Posted - 2009-05-27 : 01:20:47
|
| Thanks for your reply.Yes MSDTC service is configured in my machine.Anyway 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 Access2. Allow Remote Client3. Allow Remote Administrator4. Allow Inbound5. Allow OutboundNow the SSIS package working perfectly. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-05-27 : 09:56:01
|
| cool |
|
|
|
|
|
|
SSIS package - unable to enlist transaction