本文介绍了VS 2015 Shell中缺少针对Oledb的Oracle提供程序的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我正在迁移到SSIS 2016版本.我正在尝试在连接中将Oracle提供程序用于Oledb.

I am migrating to SSIS 2016 version. I am trying to use the Oracle provider for Oledb in connections.

但是,此选项不显示.我已经安装了Oracle客户端12.2,并且能够执行UDL文件测试,在其中可以看到Oracle提供程序并能够测试连接.

However, this option does not show. I have installed the Oracle client 12.2 and I am able to do UDL file testing, where in I can see the Oracle provider and able to test connection.

但是当我在VS 2015中尝试时,该选项未显示.

But when I try in VS 2015, the option is not shown.

此处描述了此问题- https://jorgklein.com/2011/06/02/ssis-connect-to-oracle-on-a-64-bit-machine-updated-for- ssis-2008-r2/,在此基础上,我安装了64位客户端.但是,当尝试使用连接管理器时,未显示oracle提供程序.

The issue is described here - https://jorgklein.com/2011/06/02/ssis-connect-to-oracle-on-a-64-bit-machine-updated-for-ssis-2008-r2/ and based on this I have installed the 64 bit client . But when trying to use the connection manager, the oracle provider is not shown.

该如何解决?

推荐答案

从SSIS连接到Oracle的推荐方法是使用Attunity连接器,该连接器可确保高性能且易于使用.如果选择使用Oracle Provider for OLEDB,则应下载Oracle数据访问组件(ODAC)和Oracle Visual Studio工具.

在此答案中,我将提供有关如何从SSIS连接到Oracle的详细信息,并且会提供一些指向您问题的解决方案的链接

有很多方法可以从SSIS连接到oracle:

There are many way to connect to oracle from SSIS:

这是Oracle数据访问组件(ODAC)的一部分

Which is a part of the Oracle Data Access Components (ODAC)

  • Oracle - Visual Studio Tools
  • 32-bit Oracle Data Access Components (ODAC) and NuGet Downloads
  • Oracle Provider for OLEDB

以下链接包含类似的问题:

The following link contains a similar issue:

这是Microsoft数据访问组件(MDAC)的一部分

Which is a part from Microsoft Data Access Components (MDAC)

07-17 19:11
查看更多