I have SQL Server 2008 R2 installed on Windows server 2008 R2. I have a requirement to fetch the data from Oracle using SSIS, so I have installed Oracle client (32-bit and 64-bit) along with ODAC for Oracle client.
Using OraOLEDB.Oracle provider I created a Linkedserver and able to pull the data using OPENQUERY.
But when I tried to pull the data from Oracle using SSIS (Microsoft OLEDB provider for Oracle), it is throwing the following error:
[Connection manager "OracleSourceDB"] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft OLE DB Provider for Oracle" Hresult: 0x80004005 Description: "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.".