Skip to main content

Posts

Showing posts from February, 2019

Google Search

Custom Search

Live Search

Yahoo Search


Search the web Search this site

Unable to Enlist in the Transaction

I recently received an error while trying to run a SSIS package in Visual Studio. The full error is seen as below.Error: The SSIS Runtime has failed to enlist the OLE DB connection in a distributed transaction with error 0x8004D024 "The transaction manager has disabled its support for remote/network transactions.".This error is happening when a component with transactions try to connect and manipulate data on a remote server.To avoid this error, two things can be done.* Remove the transaction handling from the component. – This should be done only if the transactions are not required or as a temporary measure.You can do this by selecting the properties of the component, also check the package properties to make sure transactions are not enabled at the package level.For an explanation of the options please visit the URL.* Configure the Distributed Transaction Coordinator (DTC).For a component to work correctly with transactions, below two things are required.
1. Running D…