Hello All, I would like to use Oracle as data source in my SSIS package. I don't have Oracle client installed so i found this link and not sure which one i need to download. Also I understand that we need both 32bit and 64bit version to be installed. So it would be of great help if any one can help me to identify the files to be downloaded and if any process is required after these installations to work with Oracle database as a source.

I am working with Windows7, SP1 64

For 32 bit ODAC refer http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html

For 64 bit ODAC refer http://www.oracle.com/us/products/tools/index-090165.html

Thanks a lot for the link. Just started to download, will install and try using Oracle as data source.

Installed both the 32 bit and 64 bit, I could see "Oracle provider for OLEDB" in the SSIS connection manager. After giving the necessary details and tested the connection i am receiving the error, "Test connection failed because of an error in initializing provider. ORA-12541: TNS:no listener" what am i supposed to do?

Contact your ORACLE DBA. You need to have updated ORA file. This file store port number, host name & protocol details of the server which you are trying to connect. ORA files are normally located under C:\ORACLE\805\Net80\Admin\TNSNAME.ORA

This file can only be provided by Oracle Server administrator.

Even if you install ORICLE client you will not be able to login Oracle using SQL Plus. This is due to missing ORA file information about the server. ODAC installation will suffice your need, the only thing is to get the updated ora

Sorry for delay response. Sure will try to check with the DBA on this issue. Thanks a lot for your information.