SSIS to Oracle Connection Issue

Reddy, Vinay Kumar 21 Reputation points
2022-10-06T11:52:31.743+00:00

Hi,

when I'm making a new connection from ssis to oracle database, the visual studio automatically getting close, what is the issue can please help me.

Visual Studio version- 2019

Oracle driver using- Oracle Clent 32-Bit (19C)

targeted SSIS run-time version- 64-Bit (2019)

Microsoft Authenticator
Microsoft Authenticator
A Microsoft app for iOS and Android devices that enables authentication with two-factor verification, phone sign-in, and code generation.
5,573 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,460 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,247 questions
Accepted answer
  1. Yitzhak Khabinsky 25,116 Reputation points
    2022-10-06T15:31:55.527+00:00

    Hi @Reddy, Vinay Kumar ,

    Please try to use SSIS Microsoft Connector for Oracle.
    It requires a mandatory SQL Server 2019 Enterprise Edition as SSIS run-time.

    It is very speedy, and doesn't require Oracle Client installation, TNSes, etc.
    Tremendous benefit for production support and operations.

    Here is its download link: Microsoft Connector for Oracle V1.2

    1 person found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 33,296 Reputation points
    2022-10-07T02:09:12.397+00:00

    Hi @Reddy, Vinay Kumar ,

    Like YitzhakKhabinsky-0887 said, it is more recommended to use Microsoft Connector for Oracle.

    You may refer to this about the detail steps.

    oracle-source

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments