SSIS package on new server - AcquireConnection failed with error code 0xC0202009

  • Hello,

    I'm moving an SSIS package from an existing server to a new server (SQL 2012 to SQL 2012) and should only need to change the connection for the OLE DB source to the new server. The destination is a flat file. I've created a new connection manager for the new server and when I 'preview' the data, I get the results I'm expecting. However, the package never writes to the destination. I've put a data viewer in the package, but the data never gets to the point of displaying the data via the data viewer, either. The error message I get is:

    SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "server.database" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.

    I have set DelayValidation to True as other posts have suggested. Does anyone have any other ideas for how to solve this problem?

    Thanks in advance, Kathy

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply