Blog Post

SQL Server Integration Services (SSIS) Blog
3 MIN READ

Microsoft Connector for Oracle is released for SQL Server 2019 Preview

Tim.Chen's avatar
Tim.Chen
Icon for Microsoft rankMicrosoft
May 14, 2019
Microsoft Connector for Oracle  is the replacement of Attunity Oracle Connector starting from SQL Server 2019 and now it is released for preview. Microsoft Connector for Oracle provides compatibility...
Updated May 14, 2019
Version 1.0
lupji's avatar
lupji
Copper Contributor
Sep 18, 2020

I am having a similar issue. We are trying to upgrade our SQL Server to 2019. Currently we have SQL Server 2017 and use Attunity driver to download Oracle data.
In 2019, we are not able to download the data. We are stuck at the connection level with this error

The AcquireConnection method call to the connection manager "Oracle Connector" failed with error code 0xC0014009. 

We are using tnsnames.ora and Oracle 64 driver for our SQL Server . 

 

Date 9/18/2020 9:16:34 AM
Log Job History (**Data Refresh-test)

Step ID 1
Server **SAZDBDEV1
Job Name **Data Refresh-test
Step Name Main
Duration 00:00:01
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message
Executed as user: **AZSQLDEV1. Microsoft (R) SQL Server Execute Package Utility Version 15.0.4053.23 for 64-bit Copyright (C) 2019 Microsoft. All rights reserved. Started: 9:16:34 AM Error: 2020-09-18 09:16:35.02 Code: 0xC0014009 Source: ** Data Refresh **OLDDB Connection manager "**_OracleConnector" Description: There was an error trying to establish an Open Database Connectivity (ODBC) connection with the database server. End Error Error: 2020-09-18 09:16:35.02 Code: 0xC020801C Source: Load ADMIN_SUPP_ROUTINGS_T Oracle Source [8] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "@@_OracleConnector" failed with error code 0xC0014009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. End Error Error: 2020-09-18 09:16:35.02 Code: 0xC0047017 Source: Load ADMIN_SUPP_ROUTINGS_T SSIS.Pipeline Description: Oracle Source failed validation and returned error code 0xC020801C. End Error Error: 2020-09-18 09:16:35.02 Code: 0xC004700C Source: Load ADMIN_SUPP_ROUTINGS_T SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2020-09-18 09:16:35.02 Code: 0xC0024107 Source: Load ADMIN_SUPP_ROUTINGS_T Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 9:16:34 AM Finished: 9:16:35 AM Elapsed: 0.625 seconds. The package execution failed. The step failed.