I have a package where I have updated the conncetion string in the config to another server where a database was moved to. I can run the package locally on my laptop with no errors but when I deploy it to our integration server and run it from a job I get the following error. Its an OLEDB connection. Any idea why its failing from the job?
SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "MyConnectionMgr" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
component "MyDataFlowComponent" (297) failed validation and returned error code 0xC020801C.
One or more component failed validation.
There were errors during task validation.