找不到Oracle客户端和网络组件 [英] Oracle client and networking components were not found

问题描述

我创建的SSIS将执行诸如从oracle到sql服务器获取数据之类的任务.我在本地系统中运行ssis软件包.运行正常，但我在远程系统中部署了ssis软件包并尝试从sql过程进行访问.我遇到如下错误.

I created SSIS will do task like get data from oracle to sql server.i run ssis package run in my local system.it is working fine but i deployed ssis package in remote system and trying access from sql procedure. I'm getting error like below.

找不到Oracle客户端和网络组件.这些组件由Oracle Corporation提供，并且是7.3.3或更高版本客户端软件安装上的Oracle版本的一部分.

Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version on 7.3.3 or later client software installation.

请告诉我们那里是否有解决方案?

Please let know if any solution there?

推荐答案

最简单的解决方案:Oracle客户端未安装在正在执行SSIS包的远程服务器上.

Simplest solution: The Oracle client is not installed on the remote server where the SSIS package is being executed.

稍微不太简单的解决方案:Oracle客户端安装在远程服务器上，但是SSIS安装的位数错误.例如，如果安装了64位Oracle客户端，但正在使用32位dtexec可执行文件执行SSIS，则SSIS将无法找到Oracle客户端. 在这种情况下，解决方案是将32位Oracle客户端与64位客户端并排安装.

Slightly less simple solution: The Oracle client is installed on the remote server, but in the wrong bit-count for the SSIS installation. For example, if the 64-bit Oracle client is installed but SSIS is being executed with the 32-bit dtexec executable, SSIS will not be able to find the Oracle client. The solution in this case would be to install the 32-bit Oracle client side-by-side with the 64-bit client.

这篇关于找不到Oracle客户端和网络组件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！