Why does the SSIS Runtime fail to start the distributed transaction?

Question

While creating an SSIS package for SQL Server 2008 i run into the following error:

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'm creating and running the package locally on my machine but the database is on a server, running Windows Server 2008, which is not in the domain.

I have made sure that the DTC service is started both locally and on the server, and I have added the Firewall exceptions that are predefined in the Windows Vista firewall.

Why does the SSIS Runtime fail to start the distributed transaction?

Answer 1

I had the same problem, however, MS DTC was not running on my machine. To turn on the Transaction Coordinator I had to do the following:

To start MS DTC

1. To open Services, on the Start menu, click Control Panel.
2. In Control Panel, click Administrative Tools.
3. In Administrative Tools, click Services. In the details pane, click Distributed Transaction Coordinator in the list of services.
4. On the Action menu, click Start.