Attunity connector for SQL Server 2019 Standard Edition

SANDEEP TADISHETTY 41 Reputation points


I installed both 32-bit and 64- bit versions of Attunity Oracle connector from Microsoft website but still do not see connectors in my Visual Studio 2019. Please let me know the process since I am trying to extract data from Oracle 19c source to SQL Server 2019 and it is very slow with OLEDB Source connection from Oracle.

Versions and Editions:

OS: Windows Server 2022 Standard Edition

SQL Server: SQL Server 2019 Standard Edition (15.0.4249.2)

Visual Studio: Visual Studio Enterprise 2019 ( 16.11.18)

Oracle Source Database: Oracle 19c

Note: I have also installed Oracle 32 bit and Oracle 64 bit admin client.


SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,468 questions
0 comments No comments
{count} votes

Accepted answer
  1. ZoeHui-MSFT 33,551 Reputation points


    Please note that SQL Server Integration Services Projects 4. versions* are not support Oracle connector yet.

    Please try to use version3.16:

    Don't forget to re-start VS after you installed the Microsoft Connector for Oracle.

    The oracle source and oracle destination will appear in common component.



    Zoe Hui

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

1 additional answer

Sort by: Most helpful
  1. Yitzhak Khabinsky 25,201 Reputation points


    Microsoft has very performant Microsoft Oracle Connector for SSIS.
    It will work on SSIS run-time server with SQL Server 2019 Enterprise Edition only.
    SQL Server 2019 with SSIS, Standard Edition will not work for such setup.