Thursday 7 August 2014

Oledb connection manager failed with error code 0xC0202009

Error Message:
[SrcExtraction [26]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The AcquireConnection method call to the connection manager "SrcServer" failed with error code 0xC0202009.  There may be error messages posted before this with more information on why the AcquireConnection method call failed.
[SSIS.Pipeline] Error: component "SrcExtraction" (26) failed validation and returned error code 0xC020801C.


Solution:
  • In the error message we can find the connection manager name (Highlighted in the above error message) which is causing the problem. 
  • Verify the user name and password, which are passed in the connection manager.
  • Verify the server (Which is mentioned in the connection manager) availability.

No comments:

Post a Comment