Friday, August 21, 2015

Errors in SSIS


Tuesday, October 30, 2012

The SSIS Runtime has failed to start the distributed transaction due to error 0x8004D01B

Error: The SSIS Runtime has failed to start the distributed transaction due to error 0x8004D01B "The Transaction Manager is not available.". The DTC transaction failed to start. This could occur because the MSDTC Service is not running.
When you try to run ssis package  you will get this above error only if you are not started Distributed transaction coordinator.

Make sure to start the Distributed Transaction Coordinator via services