Oracle Connection Manager Type is not available in SSIS 2022

Question

Oracle Connection Manager Type is not available in SSIS 2022

Packiaraj Vairan 0

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

0 comments

Answer recommended by moderator

Chaithanya Kumar 0 Microsoft External Staff Moderator

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.

Installing MicrosoftSSISOracleConnector-SQL19-x64.msi alone is not enough; an Oracle client is mandatory.
Install Oracle Data Access Components (ODAC) 19c – 64-bit (OCI based) on the machine.
During ODAC installation, select Oracle Provider for OLE DB, ODP.NET (unmanaged), and SQL*Net / OCI; do not rely on the managed driver only.
Ensure bitness matches across all components: Visual Studio 2022 (64-bit), SSIS 2019 (64-bit), Oracle Client (64-bit); avoid 32-bit Oracle client.
Verify Oracle client installation by running where oci.dll.
After installations, close all Visual Studio instances and restart Windows.
In an SSIS package, right-click Connection Managers → New Connection and check for Oracle / Oracle Connection Manager.
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.
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.

Chaithanya Kumar 0 Reputation points Microsoft External Staff Moderator

2026-01-07T05:37:21.5233333+00:00

Hi @Packiaraj Vairan , we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?

We appreciate your participation and thank you for being an active member of the community.

Thanks

2 additional answers

Your answer

Chaithanya Kumar 0 Reputation points Microsoft External Staff Moderator

2026-01-07T05:37:21.5233333+00:00

Hi @Packiaraj Vairan , we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?

We appreciate your participation and thank you for being an active member of the community.

Thanks

Answer 1

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:

It is super fast. Behind the scenes, it is using probably the best ODBC driver: Progress DataDirect Oracle Wire Protocol ODBC driver.
No need to install Oracle Client.
No need to maintain Oracle Homes.
No need to install any Oracle ODAC.
No need to configure and maintain any *.tns files
Use Oracle Easy Connect format for connection strings: EzConnect format: [//]host[:port][/service_name]. https://learn.microsoft.com/en-us/sql/integration-services/data-flow/oracle-connection-manager?view=sql-server-ver17

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

SSIS - Oracle Connector

Answer 2

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

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.
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.
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.
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:

Share via

Oracle Connection Manager Type is not available in SSIS 2022

2 additional answers

Your answer