Ch 14 Containers within Containers ... distributed services
In the Chapter 14 example 'Containers within containers and Checkpoints' I changed the TransactionOption property to Required and upon executing the package I got the error message:
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.
I navigated to and executed:
C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Administrative Tools\Component Services (Shortcut)
and expanded Services (Local). The Distributed Transaction Services was reportedly 'Running'. I double-clicked this row, and a Window popped up. I stopped the service, then then Started it. I re-executed the package and it succeeded.
|