Blog Post

SQL Server Integration Services (SSIS) Blog
2 MIN READ

General availability of Microsoft Connector for Oracle

Chunhua's avatar
Chunhua
Icon for Microsoft rankMicrosoft
May 25, 2020
Microsoft Connector for Oracle is now generally available.    Microsoft Connector for Oracle provides compatibility with Attunity Oracle Connector in functionality and performance. Packages desig...
Updated May 25, 2020
Version 1.0
Viral_Kothari's avatar
Viral_Kothari
Copper Contributor
Nov 17, 2020

I have designed my SSIS package in VS ENT 2019 version 16.7.7 having Oracle Connection Manger.

I have Oracle 12c Client Installed on my machine along with attunity driver (V5).

The package works fine on local machine (loading data from Oracle to storing to Oracle Destination) using Oracle Source and Oracle Destination.

When I deploy the package on SSIS Server (SQL Server 2014), I am getting below error.

 

Package1:Error: The connection type "ORACLE" specified for connection manager "Oracle Connection Manager" is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name.

 

SQL Server 2014 has been installed on Windows server 2012. It has same oracle client (12c) as my local machine along with relevant attunity drivers and Microsoft Connectors for Oracle which is there on my local machine.