Microsoft Connector for Oracle - missing in the list of SSIS Connection Manager after installation

PhilZ 1 Reputation point


Trying to figure out how to see and use Microsoft Connector for Oracle for SSIS package (dtsx).

currently using

VS 2019 Enterprise IDE along with SSDT.

I have download the latest Microsoft Connector for Oracle from details.aspx

Did install and reinstall many times, but did not see anything.



What am I missing?


SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,655 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,451 questions
{count} votes

3 answers

Sort by: Most helpful
  1. Yitzhak Khabinsky 24,941 Reputation points

    Hi @PhilZ ,

    I recently answered a similar question.
    Check it out here: Microsoft SSIS Connector to Oracle - doesn't work with Visual Studio 2019

    One of the huge benefits of the Microsoft SSIS Connector to Oracle, it doesn't require Oracle Client installation at all. It comes with its own Oracle ODBC driver. One of the best from the perspective of performance.
    Please see below.


    1 person found this answer helpful.
    0 comments No comments

  2. ZoeHui-MSFT 32,506 Reputation points

    Hi @PhilZ

    The following Microsoft SQL Server products are supported by Microsoft Connector for Oracle:

    Since SQL Server 2019 CU1
    SQL Server Data Tools (SSDT) 15.9.3 or later for Visual Studio 2017
    Microsoft SQL Server Data Tools (SSDT) for Visual Studio 2019

    The following Oracle database versions of data source are supported:

    Oracle 10.x
    Oracle 11.x
    Oracle 12c
    Oracle 18c (without Windows Authentication support)
    Oracle 19c (without Windows Authentication support)
    The Oracle database is supported on all operating systems and platforms.

    After you install the Connector, you must restart the SQL Server Integration Service to be sure that the Oracle source and destination can work correctly.

    In addition, the oracle connection could be use named as Oracle source and destination.

    Reference: oracle-connector


    Zoe Hui

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

    0 comments No comments

  3. PhilZ 1 Reputation point

    Thanks @Yitzhak Khabinsky and @ZoeHui-MSFT for the help.

    yes it worked this time.

    Some couple of questions...

    1. I have tried to connect using TNS Name and connection failed.


    using other driver, connection succeeded..


    And I am seeing different Oracle in SSIS toolbox... Is this correct or expected?


    1. I have seen during my google search about EZ connect ... do you have a sample how to add it on existing tnsnames.ora file?

    Update - I think I got it.... Please ignore this part.

    1. Do you have any suggestions on Oracle driver/provider which is not obsolete and best in terms of performance?

    What is your opinion about the ODP.NET vs Microsoft Connector for Oracle.?