DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER error

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.

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