Share via

Oracle Connection Manager Type is not available in SSIS 2022

Packiaraj Vairan 0 Reputation points
2025-12-24T07:51:13.5366667+00:00

I am using visual studio 2022 along with SSIS, I am not seeing Oracle Connection Manager Type eventhough i have installed the provider (MicrosoftSSISOracleConnector-SQL19-x64.msi) and i am using sql server 2019

SQL Server Integration Services
0 comments
Answer recommended by moderator
  1. Chaithanya Kumar 0 Reputation points Microsoft External Staff Moderator
    2025-12-24T15:51:40.41+00:00

    Hi @Packiaraj Vairan

    below are the few debug steps to solve your issue

    Install SQL Server Integration Services Projects extension in Visual Studio 2022 and restart Visual Studio.

    1. Installing MicrosoftSSISOracleConnector-SQL19-x64.msi alone is not enough; an Oracle client is mandatory.
    2. Install Oracle Data Access Components (ODAC) 19c – 64-bit (OCI based) on the machine.
    3. During ODAC installation, select Oracle Provider for OLE DB, ODP.NET (unmanaged), and SQL*Net / OCI; do not rely on the managed driver only.
    4. Ensure bitness matches across all components: Visual Studio 2022 (64-bit), SSIS 2019 (64-bit), Oracle Client (64-bit); avoid 32-bit Oracle client.
    5. Verify Oracle client installation by running where oci.dll.
    6. After installations, close all Visual Studio instances and restart Windows.
    7. In an SSIS package, right-click Connection Managers → New Connection and check for Oracle / Oracle Connection Manager.
    8. Verify the Oracle connector exists at C:\Program Files\Microsoft SQL Server\150\DTS\Connectors\ and contains Microsoft.SSIS.OracleConnector.dll; reinstall the connector as Administrator if missing.
    9. If the Oracle connection still does not appear, run devenv/log, review ActivityLog.xml, and confirm there is no Oracle client version or bitness mismatch.

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Yitzhak Khabinsky 27,096 Reputation points
    2025-12-24T19:02:31.0166667+00:00

    Hi @Packiaraj Vairan

    You can safely ignore previous "answers" provided by AI.

    All you need to do is to install two Microsoft Connector for Oracle V1.3:

    • MicrosoftSSISOracleConnector-SQL22-x64.msi
    • MicrosoftSSISOracleConnector-SQL19-x64.msi

    Here is the download link: https://www.microsoft.com/en-us/download/details.aspx?id=105811

    Microsoft Connector for Oracle has the following benefits:

    Eventually in SSIS Data Flow you will see two entries: Oracle Destination and Oracle Source.
    Please see below its screen shot.

    SSIS - Oracle Connector

    0 comments
  2. Q&A Assist
    2025-12-24T07:51:21.6333333+00:00
    AI generated content. This question contains an answer created with AI from Q&A Assist. Learn more

    If you are not seeing the Oracle Connection Manager Type in SSIS 2022, it may be due to a few reasons:

    1. Installation Issues: Ensure that the Microsoft Connector for Oracle is properly installed. You mentioned installing MicrosoftSSISOracleConnector-SQL19-x64.msi, which is correct for SQL Server 2019. However, ensure that you have also installed the appropriate version for Visual Studio 2022, as there may be compatibility requirements.
    2. Restart SQL Server Integration Services: After installation, it is necessary to restart the SQL Server Integration Services to ensure that the Oracle source and destination can work correctly.
    3. Check for Compatibility: Make sure that your Visual Studio 2022 is set up to target SQL Server 2019. If there are any mismatches in the versions, it could lead to the Oracle Connection Manager not being available.
    4. Visual Studio Extensions: Ensure that you have the correct SSIS Projects extension for Visual Studio 2022 installed, as this could affect the availability of certain connection managers.

    If you have checked all these aspects and still do not see the Oracle Connection Manager, you may want to consult the troubleshooting guide for further assistance.

    References:

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.