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