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!

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s