Hey Any suggestions? I have SSIS 2008 R2 on Windows Server 2008 R2 64bit (or Windows 7) and I want to use an Oracle database (10g Enterprise Edition Release 10.2.0.4.0 - 64bit) as a source for a Datamigration to SQL Server. What drivers should I install and should I use ADO.Net or OLE DB? Kind regards, Joost Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com

I prefer OLE DB over ADO.Net http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/1a9e3670-9685-4943-913b-123ecf248a9c/-------------------------------------------------------- Surender Singh Bhadauria

I prefer OLE DB over ADO.Net http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/1a9e3670-9685-4943-913b-123ecf248a9c/ Unfortunately the links in that forum thread are dead and the thread is from a time that Windows Server 2008 R2 didn't exist :-( I'm looking for drivers that can be installed on Windows Server 2008 R2 (That seems to be a problem).Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com

Hi, Please install Oracle client component (64Bit) on the server and it will install driver from oracle itself. Thats what we did in our project and it works godd. Best regards, Sengwa Best regards, Sengwa

Thanks sengwa I thought he might be knowing that to get the oledb drivers for oracle you need to install oracle client home-------------------------------------------------------- Surender Singh Bhadauria

Hi, Please install Oracle client component (64Bit) on the server and it will install driver from oracle itself. Thats what we did in our project and it works godd. Best regards, Sengwa Best regards, Sengwa Hi Sengwa, Did you got it working on Win2008R2 or Windows7(64bit)? When installing 64-bit Oracle Data Access Components (ODAC) I get an (useless) error: Java(TM) 2 Platform Standard Edition binary has stopped working: A problem caused the program to stop working correctly. Windows will close the program and notify you if a solution is available. Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com

Hi, Please install Oracle client component (64Bit) on the server and it will install driver from oracle itself. Thats what we did in our project and it works godd. Best regards, Sengwa Best regards, Sengwa Hi Sengwa, Did you got it working on Win2008R2 or Windows7(64bit)? When installing 64-bit Oracle Data Access Components (ODAC) I get an (useless) error: Java(TM) 2 Platform Standard Edition binary has stopped working: A problem caused the program to stop working correctly. Windows will close the program and notify you if a solution is available. I only got it working with the 32-bit Oracle Data Access Components (ODAC) drivers.... (and running the package in 32bit modus) Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com

Yes. BIDS is 32 bit application and it will expect Oracle 10G client component (32 bit) during the development. During deployment and automation process, SSIS package will expect 64 bit components. So you have to install 64 bit oracle client component as well. Best regards, Sengwa Best regards, Sengwa