Hi @Arun Jose ,
Here is a new component named Microsoft Connector for Oracle.
Microsoft Connector for Oracle enables the ability to export data from and load data into Oracle data source in an SSIS package.
The following Oracle database versions of data source are supported:
Oracle 10.x
Oracle 11.x
Oracle 12c
Oracle 18c (without Windows Authentication support)
Oracle 19c (without Windows Authentication support)
Please also note the following Microsoft SQL Server products are supported by Microsoft Connector for Oracle:
Since SQL Server 2019 CU1
SQL Server Data Tools (SSDT) 15.9.3 or later for Visual Studio 2017
Microsoft SQL Server Data Tools (SSDT) for Visual Studio 2019
Please refer to oracle-connector.
Regards,
Zoe
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
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.