DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Cannot Connect to Oracle using SSIS

602824Oct 11 2007 — edited Dec 17 2008

I am working with a client that has the following: a Windows Server Standard 2003 with SQL Server Standard 2005 installed. Oracle 10g is installed on a Linux Red Hat server. All are 64-bit and have the most current service packs installed. We are trying to pull Oracle data to SQL Server using SSIS and/or the SQL Server Import/Export wizard. the 10g client tools are installed on the Windows/SQL Server box. We can connect from there to Oracle using both SQL *Plus and Aqua Data Studio. However, when I try to import data to SQL Server using with the .Net or OLEDB provider, I get the error stating that I have to install the Oracle client tools.

Can anyone help with this? No one on the Microsoft side seems to have an answer.

Many thanks!

Jeanne

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 14 2009

Added on Oct 11 2007

#oracle-provider-for-ole-db, #windows-and-net

3 comments

9,013 views