how to make connectivity using SSIS with Oracle 10g

qasimidl 106 Reputation points
2023-07-14T14:03:11.6066667+00:00

Hi,

I have some xml files, want to copy these data into oracle using SSIS 2022.

Problem:

how to make connectivity (like odbc ,oledb etc etc ) with oracle to insert data into oracle table

Solution:

we downloaded SSIS Microsoft Connector for Oracle, it is giving below error, (PFA)

"Microsoft ODBC oracle wire protocol driver the data direct product, you are attempting.

to access has been provided to you by the Microsoft for exclusive use with Microsoft products. you are not licensed to use this product with any application other than Microsoft product........"

error image: oraclerroretl.PNG

we have oracle 11g.

Thank

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,641 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
547 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Olaf Helper 45,881 Reputation points
    2023-07-17T06:02:59.9733333+00:00

    we downloaded SSIS Microsoft Connector for Oracle, it is giving below error, (PFA)

    If you mean the Attunity for Oracle, it's limited to the SSIS Enterprise edition.

    Use origin Oracle ODAC = "Oracle Data Access Components" instead.

    https://www.oracle.com/database/technologies/odac-downloads.html

    1 person found this answer helpful.
    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.