Devart Forums

I have a requirement to retrieve data from an Oracle database into an Sql database using SSIS.

I am using sql Server 2012 Standard Edition 64 bit and oracle is 11g.

I tried to download the oracle drivers (64-bit Oracle Data Access Components (ODAC)) to install on the Sql server so that I could connect to Oracle db but could not achieve the same.

Please help me solve the problem.

You can use Devart ODBC Driver for Oracle to solve the described ask. To become familiar with our product, you can use the full-featured trial version, available at: https://www.devart.com/odbc/oracle/download.html Here : https://www.devart.com/odbc/oracle/compatibility.html you can get a list of compatibility of our driver. Its use in the SSIS project does not differ from any other ODBC driver

MaximG wrote: ↑Thu 15 Aug 2019 06:06 You can use Devart ODBC Driver for Oracle to solve the described ask. To become familiar with our product, you can use the full-featured trial version, available at: https://www.devart.com/odbc/oracle/download.html Here : https://www.devart.com/odbc/oracle/compatibility.html you can get a list of compatibility of our driver. Its use in the SSIS project does not differ from any other ODBC driver

Thank you. Very useful thread