Unable to Enlist in the Transaction

When running a SSIS package with several data flow task which are designed to run in parallel and if all the Data flow tasks TransactionOption property is set to the Required value you may receive the following error:

Description: The SSIS Runtime has failed to enlist the OLE DB connection in a distributed transaction with error 0x8004D00A “Unable to enlist in the transaction

This error occurs because the DTC service cannot handle multiple transaction effectively.Therefore, you need to re-design the data flow tasks to run one after the other.

Previous Package

New Package


No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |