DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER .The acquire connection method call to the connection failed with error code 0xC0014009.

Question

All,

Created SSIS package with Hadoop (source) moves data to SQL server and Postgres. ODBC is used to connect with Hadoop and Postgres. Its deployed and scheduled. working fine. connections are given using params.

Same package deployed in another server getting the error DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER .The acquire connection method call to the connection failed with error code 0xC0014009.

In that server also need to install ODBC DRIVERS for Hadoop and Postgres.

Changing connection values is not sufficient

Any assistance you can provide would be helpful!

Thanks for valuable time

Srdhar

Answer 1

Hi @Sridhar Babu Kondla

Please first check if it is a 32 vs 64-bit issue.

You will need to edit the existing SQL Agent job to change the bittedness of the job step. This will be under the Configuration tab and then under the Advanced tab. Check/Uncheck the 32-bit runtime.

Please also check that the account used to run the agent job has full permission to connect to Hadoop (source).

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.