SSIS - Cannot find Oracle connection or toolbox items?

Noah Gilbert 26 Reputation points
2022-06-27T20:26:55.657+00:00

Latest installation of VS 2019 Community as well as SSDT all updated. Also installed the SSIS extension templates. Then I installed the Microsoft Connector for Oracle.

I can create a new SSIS project but there is no Oracle connection available in Connection Manager, nor are the Oracle Source and Oracle Destination components visible.

Verified files appear to exist in the correct location, i.e.
C:\Program Files\Microsoft SQL Server\150\DTS\Connections\OracleConn.dll
C:\Program Files\Microsoft SQL Server\150\DTS\PipelineComponents\OracleDest.dll
C:\Program Files\Microsoft SQL Server\150\DTS\PipelineComponents\OracleSrc.dll

Obviously I've restarted my whole system several times, but there is no new connection type in connection manager and no new toolbox items.
....

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,456 questions
Accepted answer
  1. Yitzhak Khabinsky 25,026 Reputation points
    2022-06-27T21:34:04.707+00:00

    Hi @Noah Gilbert ,

    (0) Make sure that SQL Server Integration Services Projects extension v.3.16 installed.
    Please don't use its v.4.0 version. It is in a preview for now. It is a known limitation.
    (1) Make sure that SSIS project has TargetServerVersion = 'SQL Server 2019'
    (2) Right click [Connection Managers] entry in the Solution Explorer, and select [New Connection Manager] entry.
    (3) Select [Oracle] entry in the dialog box window like below.

    215448-microsoft-oracle-connection.jpg

    You can also check it in the ODBC drivers.

    215488-odbc-microsoft-oracle-driver.png

    1 person found this answer helpful.

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Noah Gilbert 26 Reputation points
    2022-06-27T22:16:08.817+00:00

    Thanks Yitzhak but we've actually reinstalled the connector multiple times today with no success. Odbc isn't really an option for performance reasons, and besides the connector should work. I know in the past there were issues with vs and ssdt versions being incompatible due to lackluster quality control by ms, kind of assuming the same thing here but hoping I'm wrong.

    Edit ah sorry I misunderstood, I'll check drivers in odbc admin I thought you were saying to use odbc connection

  2. ZoeHui-MSFT 33,126 Reputation points
    2022-06-28T02:12:02.48+00:00

    Hi @Noah Gilbert ，

    Are you following the official documentation to install the Microsoft Connector for Oracle?

    oracle-connector

    Microsoft Connector for Oracle V1.2

    Visual Studio is a 32bit application, you need to install the MicrosoftSSISOracleConnector-15.0.2000.215_x86.msi.

    The oracle source and oracle destination will appear in common component. Don't forget to re-start VS.

    215514-image.png

    If the issue still occurs, please report the problem to VS feedback, the product team will help to deal with the issue.

    215561-image.png

    Regards，

    Zoe

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.