问题描述
我正在迁移到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)
- Oracle的Microsoft OLE DB提供程序概述
- Microsoft OLE DB Provider for Oracle Overview
- Microsoft连接器用于Oracle和Teradata by Attunity for Integration Services(SSIS)
- Microsoft Attunity连接器
- Microsoft Connectors for Oracle and Teradata by Attunity for Integration Services (SSIS)
- Microsoft Connectors by Attunity
- SSIS Connectors for Oracle by Attunity vs Oracle provider for OLE DB performances
- Oracle Client DataProvider VS Oracle Provider for OLEDB
- 在SSIS中从Oracle导入 (从Oracle客户端安装到数据导入)
- Microsoft OLE DB Provider for Oracle(MSDAORA)for 64 bit?
- 带有Oracle连接器的SSIS
- Importing From Oracle In SSIS (from Oracle client installation to data import)
- Microsoft OLE DB Provider for Oracle (MSDAORA) for 64 bit?
- SSIS with Oracle Connectors
这篇关于VS 2015 Shell中缺少针对Oledb的Oracle提供程序的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!