While I’m trying to implement transaction handling in SSIS packages i.e Setting isolation level is ‘Serializable’ and Transaction option into ‘Required’ in the Sequence container properties,
Error is coming as like below.
[Connection manager "SSIS Package 2008R2"] 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."
Solution:
1. Put all the tasks inside the sequence container as per the below screenshot and execute the SSIS package, it will run successfully.
Hope above will helps.!!!!!!!!!
The easier solution is to set the MaxConcurrentExecutables on the package properties to 1. This makes it execute a single process at a time and avoids the error. Still not ideal as one of the benefits of the SSIS package is being able to run things concurrently.
ReplyDeleteSimilar solution discussed here:
http://stackoverflow.com/questions/674364/intermittent-failure-to-enlist-ssis-package-in-dtc-transaction
I tried that also and it did not work for me.
DeleteHi Jcrawfor74,
ReplyDeleteThanks for the comments and alternative method...
All the components in my package are connected in series. But I still get this error.
ReplyDeleteThank You and I have a swell give: Where To Learn Home Renovation average home renovation cost
ReplyDelete