Oracle source and destination missing in visual studio 2022 after installing Microsoft Connector for Oracle v1.2/1.3
We are running SSIS packages originally developed for SQL Server 2016 on servers that have been upgraded to SQL Server 2022 (both OS and database engine). The packages use the Attunity Oracle connectors. After the upgrade we attempted to open the packages in Visual Studio 2022, but the Oracle Source and Oracle Destination components do not appear in the Data Flow toolbox.
We have tried the following steps without success:
Installed both the 32‑bit and 64‑bit versions of the Microsoft Connector for Oracle (v1.2 and v1.3) as administrator.
Restarted the SQL Server Integration Services service after each installation.
Confirmed that Visual Studio 2022 has the latest SQL Server Integration Services Projects extension installed.
Despite these steps, the Oracle Source and Destination items are still absent from the Common tab in the SSIS Data Flow toolbox.
- What additional configuration or prerequisites are required for the Microsoft Connector for Oracle v1.2/v1.3 to register the Oracle Source and Destination components in Visual Studio 2022 when targeting SQL Server 2022?
- To upgrade our existing SSIS packages from SQL Server 2016 to SQL Server 2022 without rebuilding them from scratch, what is the supported migration path for packages that currently use Attunity Oracle connectors?
Read more here: Source link
