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

    Unanswered: SSIS package - unable to enlist transaction

    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
    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
  •