Solved

SSIS - Oracle Client

Posted on 2013-06-16
4
697 Views
Last Modified: 2016-02-11
I'm trying to set up a server with SSIS to connect to Oracle.
The server is windows server 2008 R2; SSIS is VS 2010.

I downloaded the instant client (64 bit) and put it in a directory.  I then set the environmental variables to both the oracle_home and tns_admin (for tnsnames.ora).

Now when I attempt to make an oracle connection in SSIS, I get the following error.

 error.jpg
0
Comment
Question by:patriotpacer
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 39251978
What data access provider are you using?

Unless it is the JDBC-Thin connection, I don't think just the Instant Client is enough.

There are additional packages, like ODBC that are available.

I've also seen posts that mention you also need the 32Bit Instant Client but I've never used SSIS or SQL Server so cannot say for sure.
0
 

Author Comment

by:patriotpacer
ID: 39253423
It does have to do with SSIS running 32 bit.

The guidance I'm seeing is to install both the 32 bit and 64 bit.  

I have the 64 bit installed now and all seems fine when I tested an ODBC connection.

But if i also install the 32 bit client what do I set the oracle_home and tns_admin variables to?
0
 

Author Closing Comment

by:patriotpacer
ID: 39253430
Just got it to work!  You were right on the 32 bit thing.

What I did to finish off was to install the 32 bit ODAC install and set the environment variables to the new 32 bit version.

I guess you may need the 64 bit if you want to do an ODBC connection?
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 39253973
>>I guess you may need the 64 bit if you want to do an ODBC connection?

ODBC doesn't care about 64 or 32 bit.  It's the apps that access the drivers.  64Bit apps, need 64Bit drivers, 32Bit apps need 32Bit drivers.

From what I read about VS and SSIS is that they mix pieces of the apps.  Some of it is 64Bit and some of it is 32Bit.

Google it.  That's how I came across it but most of it I didn't understand since I'm not a MSoft person.
0

Featured Post

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

A safe way to clean winsxs folder from your windows server 2008 R2 editions
A couple of weeks ago, my client requested me to implement a SSIS package that allows them to download their files from a FTP server and archives them. Microsoft SSIS is the powerful tool which allows us to proceed multiple files at same time even w…
This video shows how to recover a database from a user managed backup
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question