April 23, 2012 at 6:08 pm
I am trying to use SSIS to load data from Flat files into an Oracle Destination.
What installations and configrations are required for SSIS to connect to Oracle destination?
April 23, 2012 at 11:43 pm
You need to install the Oracle client and configure it.
Make sure either the Microsoft OLE DB provider for Oracle or the Oracle OLE DB provider are installed. If you have 64-bit, make sure you install 32-bit and 64-bit providers on your development PC.
After that you can use the regular OLE DB connection manager to connect to Oracle.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 4, 2012 at 3:55 am
you'll need to get the right entry in your tnsname.ora file once Oracle is set up
if you set up something in your tnsnames.ora, say "BIGDB"
you can, in MSDOS, do
tnsping BIGDB
which will tell you if that worked....
and if you have a 64 server it's fun and games, ensure you know the difference between your 32 and 64 bit TNSPING and ODBCAD32 files, so that you can test the two (I always find adding a DSN a valuable test)
Visual Studio debugs with the 32 bit drivers/tnsnames/Oracle installation and you can set a package to run off 32 bit drivers
but if you do linked server stuff, that works off the 64 drivers
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply