"Data Flow Task:Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager ""Oracle_XXXX"" failed with error code 0xC0014009. There may be error messages posted before this

Question

SSIS using task factory component and brings data from Oracle to SQL Server.

SSIS package execute successfully on dev SQL Server environment and it returns errors on production. It runs scheduled as a job.

Both servers are 2019 and identical.

Here is the error (retrieved from All Execution / Reports):

"Data Flow Task:Error: There were errors during task validation."

"Data Flow Task:Error: One or more component failed validation."

"Data Flow Task:Error: Oracle Source PROD_XXX F_XYZ failed validation and returned error code 0xC020801C."

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

"Package:Error: There was an error trying to establish an Open Database Connectivity (ODBC) connection with the database server."

Thank you,

GT

Answer 1

Hi @Gena Tamarov,

Which driver did you install, 32-bit or 64-bit? And what is your ODBC connection string? If there is no problem with the driver, it may be cause by SQL Server Agent Service Account doesn’t have access to the MySQL server. Try to create a SQL Server Agent Proxy account that has sufficient permission on the MySQL server. In addition, also noted that the package protection level setting. Please refer to this similar thread.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.