none
Error loading staging table(DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER) RRS feed

  • Question

  • Get the following error when using a project level connection. I created one connection to the DB using this connection in the control flow and i am using the same connection in the data flow to load the staging table.

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

    Tuesday, October 24, 2017 4:04 PM

Answers

  • It is an OLEDB SQL Server connection. Also the control flow has a truncate table task which executes. So i do not think its related to driver. It is failing in the data flow for loading the staging table.
    • Edited by monty4u Tuesday, October 24, 2017 5:10 PM
    • Marked as answer by monty4u Wednesday, November 15, 2017 7:22 PM
    Tuesday, October 24, 2017 5:08 PM

All replies