Following is the error message when running the SSIS package which contains Transaction for batch processing of the data.
Error:
0xC001401A at Transaction: 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.
Resolution:
Start the service "Distributed Transaction Coordinator"
1. Go to Start menu - Run command
2. Type services.msc
3. Start the service "Distributed Transaction Coordinator" where the packages are executing.
