What do we need to use Oracle as data source with SSIS?

Question

Hi,

I am using the following setup to develop SSIS packages:
SQL server 2017
SSDT for Visual Studio 2017 version 15.9.9
Oracle 12c 64-bit

In order to import data from Oracle database, what do I need to install (Oracle client , ODAC , Attunity, etc.)

Please specify all needed components and whether I need the 32-bit or 64-bit version of each.

Thanks and regards

Answer 1

Hi @RNA-9746，

Microsoft Connector for Oracle enables the ability to export data from and load data into Oracle data source in an SSIS package.

oracle-connector

oracle-connection-manager

For 64bit and 32bit issue, you may refer this which mentioned the prerequisites about the environments.

Regards，

Zoe

---

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

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October