November 12, 2013 at 8:07 am
I need to create an SSIS package that connects to an Oracle 10g database on another server.
I am running a Windows 2008 R2 server with SQL Server 2008 R2.
I have researched how to connect and before I begin I have a couple questions.
Oracle Instant Client has a 'basic' instant client, an 'odbc' instant client and a 'sqlplus' instant client.
Do I need both the basic and the odbc instant client installed for both 32 bit and 64 bit version?
Are the oracle instant clients the same for Windows Server OS vs Windows Desktop OS?I am following the instructions posted at here. It was the most complete instructions I could find.
http://jerryaspnet.blogspot.com/2012/05/configuring-ssis-2008-to-connect-to.html
Thank you for the help.
November 19, 2013 at 8:06 am
Using a few links and by trial and error. I was able to configure Microsoft Connector for Oracle by Attunity.
I used the following posts with the following clarifications:
I downloaded and installed the Oracle Instant Client as directed in this post:
http://jerryaspnet.blogspot.com/2012/05/configuring-ssis-2008-to-connect-to.html
This post did not specifiy if I needed anything other than the 'Basic' Oracle Instant Client.
I only needed the Basic Client for the connection to work.
I also downloaded the SQL Plus client to test the connection outside of SSIS.
Also the word 'install' implied to me I would run an .exe of some sort. In Jerry's directions, he specifies unzipping the files and moving the files to a directory. 'Unzipping and moving the files' is the install.
After Unzipping and moving the files for the instant client, you must manually update the Registry as found in the link he provides... also below
http://msdn.microsoft.com/en-us/library/ee470675(v=sql.100).aspx
The Only Registry Entry I added was the ORACLE_HOME that pointed to my tnsnames.ora directory
Then I installed the Microsoft Connector for Oracle by Attunity per the instructions in the above link.
I did receive an error message during the install that said it had an issue with writing to the registry.... However, I was able to complete the install and add the Oracle Source and Destination Connections inside SSIS and connect to the Oracle Database just fine.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply