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

RNA 1 Reputation point


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

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,523 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 35,546 Reputation points

    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.



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



    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