Below is the error message I am getting.
"Test connection failed because of an error in initializing provider. Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation.
Provider is unable to function until these components are installed."
I am working with SQL Server Integration Services (SSIS). When I am trying to select OLEDB source as Oracle 10g database I am getting this error.
Platform Details:
I have a Windows 2003 Enterprise Edition server 64 bit running SQL Server 2008 Standard Edition 64 bit with Oracle 10.2.0.1.0 64 bit client installed.
Please help me with this problem. Why I am getting this error? and what needs to be done to fix this?
Thanks in advance.