I am working on a SSIS task in which i need to get data from Oracle database which is on remote server.
But when created the SSIS package and tried to create the connection from the connection manager using OLE DB connection, I am not able to find the provder 'Oracle Provider for OLE DB' . I have oracle client, toad installed on my machine.Using toad, I am able to connect to the Oracle database.
Please suggest. For time being I am using 'Microsoft OLE DB provider for Oracle' to make the SSIS working.
Edited by: 982652 on Jan 17, 2013 11:02 PM
Without any information about your setup it's hard to say what's going wrong here, but the most frequent cause I see is a mismatch between a 64 bit program and a 32 bit Oracle client (or vice-versa).
Which Oracle client did you install? What version of SSIS and Windows are you using?
Alright, so it's not that. It's possible the OLE DB provider isn't installed, depending on how you installed the Oracle client.
This link has a little windows script that can list all the known OLE DB providers. That should tell you if its installed and SSIS isn't finding it, or if it's not installed at all. http://www.motobit.com/help/regedit/sa117.htm
Yes, oraoledb provider does not exists on my m/c.
Should I download the setup file which is aprox 230mb on the Oracle site or is there any other way to register the dll since its a big file and downloading it on my offc m/c is not feasible.
Edited by: 982652 on Jan 22, 2013 4:28 AM
AFAIK the xcopy installer has an installer for the OLE DB provider in it, you'd probably just have to run that for the version of Oracle you have.
The full installer will definitely install it, though. That's what I prefer to use.