DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER error

Question

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.

Answer 1

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 manager and create new one.

Most of the time first way solves the problem.