未找到 Oracle 客户端和网络组件

2021-12-30 00:00:00 sql oracle ssis

我创建的 SSIS 将执行诸如从 oracle 获取数据到 sql server 之类的任务.我在本地系统中运行 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?

推荐答案

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

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

稍微不那么简单的解决方案:Oracle 客户端安装在远程服务器上，但 SSIS 安装的位计数错误.例如，如果安装了 64 位 Oracle 客户端，但 SSIS 正在使用 32 位 dtexec 可执行文件执行，则 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.

相关文章