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?