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

sql-server ssis msdtc
Cros picture Cros · Sep 15, 2009 · Viewed 24.3k times · Source

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

Flea picture Flea · Feb 7, 2017

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.

Related questions

'Microsoft.ACE.OLEDB.16.0' provider is not registered on the local machine. (System.Data)

I get this error when I try to connect to any excel through MSSQL Server Data Import i.e. SSIS package The Microsoft.ACE.OLEDB.16.0 provider is not registered on the local machine. (System.Data) It is not the same …

Read More
Text was truncated or one or more characters had no match in the target code page including the primary key in an unpivot

I'm trying to import a flat file into an oledb target sql server database. here's the field that's giving me trouble: here are the properties of that flat file connection, specifically the field: here's the error message: [Source - 18942979103_txt [424]] …

Read More
How do I fix the multiple-step OLE DB operation errors in SSIS?

I'm attempting to make a DTS package to transfer data between two databases on the same server and I'm getting the following errors. Iv read that the Multiple-step OLE DB operation generated error can occur when you are transferring between …

Read More