My package consists of dynamic db connections. When I run my package, it throws an error, for example, DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method method calls the conn manager with error code 0xC0202009.
I tried setting the delay check property to true at the package level.
I tried to change the packet security level property to EncryptSensitiveWithpassword. Still facing the same error.
Ability to run the package manually.
How to get rid of this.
source
share