Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER: error code 0xC020801C Expand / Collapse
Author
Message
Posted Tuesday, September 2, 2014 1:27 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, September 18, 2014 7:27 AM
Points: 331, Visits: 750
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.

Post #1609764
Posted Tuesday, September 2, 2014 2:10 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, September 18, 2014 7:27 AM
Points: 331, Visits: 750
Additional info. Its a pkg developed in VS 2008 and Im connecting to a SQL 2012 datasource
Post #1609787
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse