question

ForestSenseiDBA avatar image
ForestSenseiDBA asked

SSIS AcquireConnection error

Hi I hope the Gods of SQL Server and SSIS can help me: I Have some developers developing a SSIS package selecting data and moving it to a different environment, but they keep getting this error on one component. [OLE DB Source [2]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Servername.tablename" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. They think it is a DTC issue, but I am not sure as there are no differences between the Source and the destination. Also within the package the data flow is in a container the data flow works fine when it is run without the container but not within. The Sequence Container has to be set to required for the Transaction Option. So far i have tried the following: 1. Confirmed the DTC is set the same on both the Source and Destination Servers 2. Tried changing it to only run in 32 bit mode 3. Tried changing the Delay validation from Talse to True and Vice Versa Any Suggestions would be appreciated
ssis
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

As it says "There may be error messages posted before this with more information on why the AcquireConnection method call failed.". Let us know what it is. Scrolling up a few lines will get you there. Prima-facie, it looks like the OLEDB connection setup is not correct. Is the connection in the connection manager tested to success? Also is the referred name "Servername.tablename" the same in the connection manager and the Source task componenet in the data flow?
1 Like 1 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.