Problem with connection to Oracle from SSIS (64bit) - 11-09-2006 , 09:37 AM
We would like to fetch data with SSIS from Oracle 10g to a Windows Server
2003 64-bit with SQL server 2005 Enterprise 64-bit.
The SSIS package is deployed to the server and executed with 64-bit dtexec
command line utility or as an SQL Server job.
We have installed Oracle 10g client 64 bit and verified that we can reach
oracle with SQL Plus.
How do we accomplish this ?
Can we install MDAC 64-bit and use ODBC connectivity to Oracle and where can
we find this ?
Today we run on 32-bit and use Microsoft ODBC for Oracle and its working