C:WindowsSystem32odbcad32.exe
, Oracle client with both versions installed 32 bit and 64 bit.PATH
environment variable to point to the ORACLE_HOME
that you want to use.PATH
to add ;C:oracleinstantclient32_12_1
on the end and it worked perfectly, no restart needed.C:oracleinstantclient32_12_1
directory I specified contains files like oci.dll
and ociw32.dll
and belonged to the 32-bit Instant Client install. I guess it doesn't matter for 64-bit, since there is no Microsoft ODBC 64-bit client.dtexec
executable, SSIS will not be able to find the Oracle client.The solution in this case would be to install the 32-bit Oracle client side-by-side with the 64-bit client.C:WindowsSystem32odbcad32.exe
, Oracle client with both versions installed 32 bit and 64 bit.Edit the system environment variables
Edit Path
Oracle client 32 bit
in front of the path for Oracle Client 64 bit
.