Back to discussion

Connect To Oracle Using SSIS

Last post was 02 Mar 2008 at 00:15
sql server United Kingdom
  • 13 years ago

    I need to use SSIS to connect to an Oracle backend. Initially I thought it would be just a question of using the OLE-DB Oracle provider, and I would be up and running. However, I shortly realised that I needed to download the Oracle Client. I went to Oracle and downloaded the free basic client. Altered the Windows PATH environment variable to accomodate the new Oracle DLLs, but am sure I'm still missing something, as SSIS keeps on telling me to install the oracle client before the OLE-DB can be used. Can anyone point me in the right direction, or even better give beginning to end steps on setting up a connection twix SSIS and Oracle?

     

    Thanks in advance

    Report abuse

Post a reply

No one has replied yet! Why not be the first?

Sign in or Join us (it's free).

SQL Server forum discussion

SQL Server tutorials

Quick links

Recent activity

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Web Development

Developer Jobs

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

Cancel
“An expert is a man who has made all the mistakes that can be made in a very narrow field” - Niels Bohr