Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am using SSIS to pull data from Oracle DataSource. In the Connection when I chose the Oracle provider and gave the necessary inputs I got error saying "Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation"

Later I installed Oracle client and it resolved the issue.

But the problem is I can't install Oracle Client in my deployment server. I read few links that I can use ODBC with SSIS for Oracle. Will it work instead of Oracle Client ?

If yes, where can I download the ODBC Driver? The link I came across is:

http://www.oracle.com/technetwork/database/windows/downloads/utilsoft-098155.html

Where I don't get the 11g version, even 10.2 version I downloaded but no setup files were found and only DLL is there!

Any help on installing ODBC drivers for Oracle will be much appreciated.

share|improve this question
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.