SSIS: Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER

You might encounter this problem, while you debug or execute the SSIS package in SQL Server Business Intelligence Development Studio.

No need to worry first of all, it is a simple fix!

Firstly, while you debug, change the Run64BitRuntime property to False in the SSIS Property Pages. Click Ok and try executing the script.

Untitled

But you may again encounter, the error message, while you add this SSIS as a Job in the SQL Server Agent. The process to fix the problem is mentioned below.

After you deploy the package in SQL Sever, you need to change the driver type for the SQL Server Step to 32/64 bit driver.Screeshot

Cheers!