Oracle Client and Network Components Not Found

Question

I created SSIS, will perform the task, for example, to get data from oracle to sql server.i to run the ssis package running on my local system. It works fine, but I deployed the ssis package to the remote system and tried to access from the sql procedure. I get an error as shown below.

Oracle client and network components not found. These components are supplied by Oracle and are part of the Oracle software version 7.3.3 or later.

Please advise if there is any solution there?

Answer 1

The simplest solution: The Oracle client is not installed on the remote server running the SSIS package.

A slightly less simple solution: the Oracle client is installed on a remote server, but in the wrong number of bits to install SSIS. For example, if you installed the 64-bit Oracle client, but SSIS runs with the 32-bit dtexec , SSIS will not be able to find the Oracle client. In this case, the solution would be to install the 32-bit Oracle client next to the 64-bit client.

Answer 2

Used technology: Windows 7, UFT 32 bit, ODBC data source pointing to 32-bit C:\Windows\System32\odbcad32.exe , Oracle client with both versions installed 32-bit and 64-bit.

What worked for me:

1.Start → search Edit the system environment variables
2. System variables → Edit Path
3. Place the path for Oracle client 32 bit in front of the track for Oracle Client 64 bit .

Example:

 C:\APP\ORACLE\product\11.2.0\client_32\bin;C:\APP\ORACLE\product\11.2.0\client_64\bin 

Answer 3

1.Return to my computer properties
2. Click the Preview button.

3.Go for the environment variable
4. Set the path to

  F:\oracle\product\10.2.0\db_2\perl\5.8.3\lib\MSWin32-x86;F:\oracle\product\10.2.0\db_2\perl\5.8.3\lib;F:\oracle\product\10.2.0\db_2\perl\5.8.3\lib\MSWin32-x86;F:\oracle\product\10.2.0\db_2\perl\site\5.8.3;F:\oracle\product\10.2.0\db_2\perl\site\5.8.3\lib;F:\oracle\product\10.2.0\db_2\sysman\admin\scripts; 

change your drive and folder depending on your requirement ...

Answer 4

After installing Oracle Client components on the remote server, restart the SQL Server agent from the PC management console or directly from Sql Server Management Studio. This will allow the service to properly load the path to the Oracle components. Otherwise, your package will work at design time, but will not work at run time.

Answer 5

In my case, this happened because a file named ociw32.dll was placed in c: \ windows \ system32 . However, this is only allowed in c: \ oracle \ 11.2.0.3 \ bin .

Removing the file from the system32 that was placed there when installing Crystal Reports fixed this problem