Microsoft Connector for Oracle

2023-12-20T15:22:14.5733333+00:00

What are all the components that will be installed once this package is deployed to the machine ? can we have a list ?

How do we test if this component is installed in a machine ?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,456 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,642 questions
0 comments No comments
{count} votes

Accepted answer
  1. Yitzhak Khabinsky 26,376 Reputation points
    2023-12-20T15:37:38.8933333+00:00

    Hi @Rajagopalan, Ganesh : Functions Technology,

    What are all the components that will be installed once this package is deployed to the machine ? can we have a list ?

    One single component needs to be installed: Microsoft Connector for Oracle V1.2

    Download link: https://www.microsoft.com/en-us/download/details.aspx?id=104113

    How do we test if this component is installed in a machine ?

    Behind the scenes it installs ODBC driver. So, go to the Control Panel / Administrative Tools, and launch ODBC Data Sources. Its Drivers tab will show Microsoft Oracle ODBC Driver.

    Please see below.

    For MS SQL Server 2019, location of the SSIS component, which is one single file, is here:

    C:\Program Files\Microsoft SQL Server\150\DTS\Connections\OracleConn.dll

    ODBC drivers located here: C:\Program Files\Microsoft SQL Server\150\DTS\Binn\ODBC Drivers

    OracleConn.dll

    Microsoft Oracle ODBC Driver

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.