Microsoft SSIS Connector to Oracle - doesn't work with Visual Studio 2019

Kacper Pabjanczyk 21 Reputation points Microsoft Employee
2022-08-11T15:57:38.643+00:00

Hello,

I have VS 2019 Enterprise version 16.11.16. I've installed Microsoft SQL Server Integration Services Designer Version 16.0.694.0. On top of it I've installed latest version of Microsoft Connector for Oracle both 64 and 32 bits, but because of unknown reason I'm not able to create connection to Oracle and in SSIS toolbox in DataFlow section I don't see Oracle Source and Oracle Destination? Please advice.

Best regards

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

Accepted answer
  1. Yitzhak Khabinsky 20,721 Reputation points
    2022-08-11T19:41:18.137+00:00

    Hi KacperPabjanczyk-3239,

    Please make sure that you have installed the following:

    • VS2019 latest build.
    • SQL Server Integration Services Projects extension for VS2019 v.3.16.
      Do not use v.4.0 preview, or v.4.1.
    • Microsoft Connector for Oracle v.1.2
      When you install its 64-bit edition, it installs both 32-bit and 64-bit drivers.

    And make sure that SSIS project TargetServerVersion setting value is SQL Server 2019

    1 person found this answer helpful.
    No comments

0 additional answers

Sort by: Most helpful