Vignesh Kumar
Reputation: 31
How to connect Sql server using SSIS package with Oracle database to different machine?
I am new to Oracle database. I am trying to connect the SQL server using SSIS package to Oracle database which is present in different machine.
There is default Oracle provider in SSIS but it's not connecting to the database. I use db visualizer for creating Oracle database in the server machine.
Upvotes: 1
Views: 4604
Answers (1)
Hadi
Reputation: 37313
You need to install the "Oracle Data Access Components" or "Oracle Client" on your machine.
There are a lot of step-by-step article on how to connect to Oracle using SSIS:
- Steps To Connect SSIS to Oracle
- Connecting to Oracle Database using Sql Server Integration Services
- Connecting to Oracle 11g on 64-bit (x64) machine SSIS 2012
- SSIS to Oracle Connection
Oracle ODAC download link
- 32-bit Oracle Data Access Components (ODAC) with Oracle Developer Tools for Visual Studio
- 64-bit Oracle Data Access Components (ODAC) Downloads
Upvotes: 2
Related Questions
- Error while setting up a connection with Oracle Connection Manager in SSIS
- Connecting Oracle via SSIS failed due to error ORA-01019
- Connect SSIS in local machine to a remote server oracle database
- SSIS connection to Oracle using Windows authentication
- SSIS 2012 - Connecting to Oracle
- Connecting to Oracle Database using Sql Server Integration Services
- How to connect to Oracle db from SSIS/SQL Server Data Tools?
- Attempting to connect to ORACLE with SSIS
- SSIS 2008 Oracle Connectivity
- SSIS connecting to Oracle 10g Error