SSIS package Transaction Error: 0x8004D01B The Transaction Manager is not available

Categories: Database; Tagged with: ETL • SQL Server • SSIS; @ December 9th, 2012 11:43

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

make sure the service called”Distributed Transaction Coordinator” is running.

在SSIS/DTSx中使用事务管理 Using Transaction in SSIS DTSx package <-> Modify SSIS package’s ProtectionLevel and password using C#