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.