Results 1 to 1 of 1
  1. #1
    Join Date
    May 2009

    Unanswered: SSIS package - unable to enlist transaction


    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?

    Last edited by raj4582; 05-26-09 at 09:02.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts