VS 2015 Shell中缺少针对Oledb的Oracle提供程序 [英] Oracle provider for Oledb missing in VS 2015 Shell
问题描述
我正在迁移到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.
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)
此功能将在Windows的将来版本中删除.避免在新的开发工作中使用此功能，并计划修改当前使用此功能的应用程序.而是使用Oracle的OLE DB提供程序.
This feature will be removed in a future version of Windows. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Instead, use Oracle's OLE DB provider.
- 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客户端安装到数据导入)
- 带有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
Microsoft选择了Attunity用于Oracle和Teradata的高速连接器，以包含在SQL Server Integration Services(SSIS)中.
Attunity's high speed connectors for Oracle and Teradata have been selected by Microsoft to be included with SQL Server Integration Services (SSIS).
这篇关于VS 2015 Shell中缺少针对Oledb的Oracle提供程序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
