Installing Oracle Oledb Provider for SQL Server 2008 R2 September 3, 2012
Posted by furrukhbaig in Oracle Oledb Provider, SQL Server 2008 R2, SSIS.Tags: Oracle 64 bit SSIS, Oracle Oledb SSIS, Oralce OLEDB Provider, SQL server 2008 R2
1 comment so far
I have found this very useful post to solve classic problem of getting data from oracle using SSIS as BID needs 32 bit driver for design time and runtime require 64 bit (on 64 bit machines).
I myself will try to do it as need to configure SQL Server 2008 R2 machine to pull data from Oracle database using SSIS. I am bit exicited as in past had tons of issues with Oracle connectivity from SSIS.
SSIS / SQL Server / Performance Tuning 