Hi, I created SSIS package which takes data from all production servers and insert that to repository. When I try to run package, it is running for few and then it is showing following error.
[OLE DB Source ] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Dynamic_SQLServerConn" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
asked Aug 26, 2014 at 02:26 PM in Default
If you are setting the connection dynamically then it probably isn't valid at package startup since it hasn't been assigned the dynamic value.
Set the delay validation property to True and see if that fixes it up (right-click the design surface and select properties)
answered Aug 26, 2014 at 02:45 PM