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.
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With