Oracle Install for SSIS 连接（和驱动程序 32 64 位）
我有一个 SSIS 包 (SQL 2008)，需要使用它连接到 Oracle DB (11g)。我需要安装什么才能连接到 oracle？术语是什么？我所做的所有搜索都谈到了 Instant Client，但是在下载时我没有看到任何 exe 文件？我知道安装服务器会给我 Oracle Net 管理器（更新 TNSNames.ora 的 UI），但我不想安装整个服务器。那样就太过分了。最小的占用空间是多少，以便我可以通过 SSIS 中的连接管理器创建与 Oracle DB 的连接？
另外即时客户端和即时客户端之间有什么区别？ Oracle 客户端工具等？有太多晦涩难懂的术语（至少对我来说），令人困惑。
PS - 阅读 http://www.oracle.com/technetwork/topics /dotnet/index-085163.html 你可能会认为这就是我想要的，但下载的只是一个 install.bat，似乎什么也没做！这是我迄今为止尝试过的典型“解决方案”。
I have an SSIS package (SQL 2008) that I need to connecto to an Oracle DB (11g) with. What do I need to install to connect to oracle? What's the terminology ? All searches I've done talk about Instant Client, but on downloading that I see no exe's? I know installing the server will give me that Oracle Net manager (UI to update TNSNames.ora) but I don't want to install the entire server. That to be is overkill. What's the smallest footprint so that I can create a connection to an oracle DB via my Connection Manager in SSIS?
Also what's the difference between Instant Client & Oracle Client tools etc? There's so much arcane (atleast to me) terminology that it's confusing.
P.s. - From reading http://www.oracle.com/technetwork/topics/dotnet/index-085163.html you would think this was what I wanted, but the download just has an install.bat that seems to do nothing! Typical of the "solutions" I've tried so far.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
嗯，我所做的是从 http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html 。它有 4 个安装选项，其中之一是即时客户端（这对我没有帮助）。有效的方法是运行时客户端或类似的名称。它安装了我想要的网络管理器。
PS-补充一下（当我遍历 Oracle 64 位旅程时），我发现我无法将 SSIS 与 64 位 Oracle DB 提供程序一起使用。我遇到了异常（在 SSIS 中添加连接时）：
我猜这是因为SSIS进程是32位进程，不能使用64位oracle驱动程序（我的主机是Win 7 64位）。
经过测试，我发现确实是这样。 我们仅需要 SSIS IDE 的 32 位驱动程序，但在使用 64 位 dtexec.exe 运行 DTSX 包时可以使用 64 位驱动程序 (C:\Program Files\Microsoft SQL Server\100\DTS\ Binn）
因此在 DEVELOPMENT（在 64 位计算机上）中安装 32 和 64 位客户端：
32 位：用于在 Visual Studio IDE 中进行开发
64 位：在命令行上使用 64 位版本的 dtexec.exe 运行 DTSX 包（就像我们在生产环境中运行它时的情况一样）
类似的线程 此处。
Well, what I did was download Oracle Database 11g Release 2 Client (11.2.0.1.0) for Microsoft Windows (x64) from http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html. It had 4 options for installing One of them being Instant Client(which did not help me). The one that works is Runtime client or something named like that. It installs Net Manager which is what I want.
PS-Adding on (as I traverse the Oracle 64 bit journey), I find that I cannot use SSIS with 64 bit oracle DB providers. I get the exceptions (on adding a connection in SSIS):
I'm guessing this is because SSIS process is a 32 bit one and cannot use 64 bit oracle drivers (my host machine is Win 7 64 bit).
After testing, I found that this is indeed the case. We need the 32 bit drivers only for the SSIS IDE but can use 64 bit when running the DTSX package using the 64 bit dtexec.exe (C:\Program Files\Microsoft SQL Server\100\DTS\Binn)
So in DEVELOPMENT (on a 64 bit machine) install both the 32 and 64 bit clients:
32 bit: for development in Visual Studio IDE
64 bit: To run the DTSX package using the 64 bit version of dtexec.exe on the command line (as would be the case when we run this in a production environment)
A similar thread here.
我不确定安装客户端和 Oracle 客户端工具之间的区别。我一直用后者。下面的链接提供了 10g 客户端工具的下载（在 Oracle Database 10g 客户端第 2 版下），这应该是您从 SSIS 获取连接所需要的。
http://www.oracle.com/technetwork/database /10204-winx64-vista-win2k8-082253.html
I'm not sure of the difference between the Install Client and the Oracle Client Tools. I've always used the latter. The link below has a download for the 10g client tools (under Oracle Database 10g Client Release 2), which should be what you require to get the connectivity from SSIS.
http://www.oracle.com/technetwork/database/10204-winx64-vista-win2k8-082253.html
我使用此链接 配置 SSIS 2008 连接到 Oracle 并成功让 VS 2012 将 SSIS 与 Oracle 11.2 instantclient 结合使用。全部归功于作者 Jerry Dy。注意：唯一需要的注册表项是 ORACLE_HOME 注册表项。
I used this link Configuring SSIS 2008 to Connect to Oracle and was successful getting VS 2012 to use SSIS with Oracle 11.2 instantclient. All credit to the author, Jerry Dy. NOTE: The only registry entry required is the one for ORACLE_HOME.