install oracle client 32 bits on 64 bits windows
ANNECMar 14 2012 — edited Oct 20 2017We need to intall Oracle driver for OLEDB on a SQL server box.
The SQL server is windows 2008 R2 and SQL server 2008 R2, 64 bits.
But because we have some SSIS packages that need to run in 32 bits,(for example the source file is the Excel), so we are installing oracle client 32 bits instead of 64 bits on the windows box which is 64 bits.
Anyone knows if this will work?
Thanks