DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER error

▲
10
▼

My package consists of dynamic db connections. When i run my package it is throwing error like DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.The AcquireConnection method call to the connection manager "conn" failed with error code 0xC0202009.

I tried setting delay validation property to true at package level.

I tried to change Package Protection Level property to EncryptSensitiveWithpassword. Still am facing with same error.

Am able to run the package manually.

How to get rid of this.

ssis
asked on Stack Overflow May 8, 2012 by user1348424 • edited May 8, 2012 by user1348424

4 Answers

▲
11
▼

This can be solved in 2 ways

First, i have changed my delay validation property at package level to True from false.

Change ProtectionLevel to EncryptSensitiveWithUserKey.

Second, Remove the old connection mamanger and create new one.

Most of the time first way solves the problem.

answered on Stack Overflow May 29, 2012 by user1348424
▲
1
▼

Convert the package to Package deployment model Please create a Package configuration file for the Connection String. Save the password here. When you deploy the package to a separate environment, copy the package along with the configuration file. Make sure the path in local and new environment is the same. This solved my problem

answered on Stack Overflow Jul 12, 2018 by Ashvini Mukundarao
▲
0
▼

I had this error keep reappearing because I forgot my connection string was created on the fly using variables and an expression (see image). Once I edited the connection string there then this error went away.connection string

answered on Stack Overflow Jul 6, 2017 by Tom McDonald
▲
0
▼

I have added port number along with the DB name and added Provider as SQLNCLI11 in dts(config file) and added port number along with the IP address in the dtsx file(SSIS package) and it worked for me.

answered on Stack Overflow Dec 12, 2019 by Madhu karan

User contributions licensed under CC BY-SA 3.0