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.
Transfer data from an Oracle database into an Sql database.
-
EricChambers_1
- Posts: 1
- Joined: Thu 08 Aug 2019 04:52
- Location: https://www.innovecs.com/
- Contact:
Re: Transfer data from an Oracle database into an Sql database.
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
Re: Transfer data from an Oracle database into an Sql database.
Thank you. Very useful threadMaximG 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