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
slakshmi22's avatar
slakshmi22
Copper Contributor
Jul 18, 2022

I am using Visual Studio enterprise edition 2019 with SSDT version 16.0.xxxxx

I have installed MicrosoftSSISOracleConnector. When I open ToolBox in Integration Service project, Oracle Source and Destination components are not available. I tried both 32 and 64 bit versions. Am I missing something?  I installed SQL Developer Edition with cumulative updates installed.. 

I need to migrate data from Oracle to MSSQL and want to use the new OracleConnector. 

Steps that I followed

1. Install Visual Studio enterprise edition 2019

2. Select SSDT and install 

3. Installed MicrosoftSSISOracleConnectorX64.msi

4. Created new Integration Service project and added Data flow Task

5. Oracle Source/Destination not available in ToolBox. 

6.  Installed MicrosoftSSISOracleConnectorX86.msi

7. Reopened Visual Studio and created new Integration Service project

8. Still Oracle Source/Destination not available in ToolBox.