Error after upgrading VS 2019 16.11.19 , SSIS designer 16.0.948.0 using Microsoft Connector for Oracle v. 1.0

Alexe, Mihai 46 Reputation points
2022-11-08T12:40:02.997+00:00

I have upgraded a SSIS solution from Visual Studio 2019 Version 16.7.4 to Visual Studio 16.11.19
From SSIS extension : 3.10 to SSIS Extension : 16.0.948.0
Targeted server version for Deployment : 2019 ( both before and actual).

Previously the Oracle connection used : Microsoft Connector for Oracle V 1.0.

After the upgrade, the project and all the ssis packages using the connection manager for Oracle fail.
This connection manager can not be loaded, ssis packages using it fail and the project / solution fails as well.
The error message: ![258277-image.png][1]

I've tried installing and unistalling in turn all of Microsoft connectors for Oracle v. 1.0, then 1.1 and then 1.2 ( both 32 and 64 bit versions ) even several times but it did not help so far.

Thank you very much for any ideas that can help me solving this issue, as I'm really under pressure.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,488 questions
{count} votes

Accepted answer
  1. Yitzhak Khabinsky 25,386 Reputation points
    2022-11-08T13:56:26.16+00:00

    Hi @Alexe, Mihai ,

    Please make sure that you have the following installed:

    1. VS2019 16.11.*
    2. SQL Server Integration Services Projects extension for VS2019, version 3.16
      And uninstall any version of it: 4.0, 4.1, 4.2, etc. These are experimental versions, and they don't support Microsoft Connector for Oracle.
    3. Microsoft Connector for Oracle v.1.2
    0 comments No comments

3 additional answers

Sort by: Most helpful
  1. Alexe, Mihai 46 Reputation points
    2022-11-08T14:15:01.327+00:00

    Hi @Yitzhak Khabinsky

    Thank you so much for your answer.
    Just to be sure : Is it the right way in order to have version 3.16
    to go to : https://marketplace.visualstudio.com/items?itemName=SSIS.SqlServerIntegrationServicesProjects , then scroll down and install it by clicking on:

    258317-image.png

    Thank you.


  2. ZoeHui-MSFT 34,581 Reputation points
    2022-11-10T01:46:19.723+00:00

    Hi @Alexe, Mihai ,

    As YitzhakKhabinsky-0887 said that SSIS 4.* versions do not support Microsoft Connector for Oracle temporarily, please uninstall it and install the v3.16.

    Version 3.16 is the latest general availability (GA) version.

    Also do not forget to "Accept Answer" on his reply so that we could archive the case.

    Regards,

    Zoe Hui

    0 comments No comments

  3. Alexe, Mihai 46 Reputation points
    2022-11-10T06:32:27.057+00:00

    Thank you for your feedback.

    0 comments No comments