SSIS 2008 Oracle 连接 [英] SSIS 2008 Oracle Connectivity

问题描述

我尝试使用 OLE DB 源(即 Microsoft OLE DB Provider for Oracle)连接到 Oracle DB.我可以连接.但是当我点击 OLE DB Source 中的 Preview 按钮时，我在预览之前收到了一条警告信息.请看下面:

I have tried to connect to Oracle DB using OLE DB Source ie Microsoft OLE DB Provider for Oracle. I am able to connect. But when I clicked on Preview button in OLE DB Source, I received a warning message before previewing.Please see below :

除此警告消息外，我可以进行预览.我们应该使用哪个提供程序来连接 Oracle?Microsoft OLE DB Provider for Oracle 或 Oracle Provider for OLE DB ?

I am able to preview except this warning message. Which provider should we have to use for connecting Oracle ? Microsoft OLE DB Provider for Oracle or Oracle Provider for OLE DB ?

推荐答案

要使用原始提供程序，您只需指定代码页.我遇到过同样的问题.对于 Oracle 的连接，我必须设置 AlwaysUseDefaultCodePage = True

To use the original provider, you simply need to specify the code page. I had the same issue. for the connections for Oracle, I had to set the AlwaysUseDefaultCodePage = True

在此处查看图像:数据流组件属性

有关如何设置的说明，请查看此处:http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/dc1a61f2-1ab8-4ed3-b85c-db6481800b50/

For instructions on how to set this, look here: http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/dc1a61f2-1ab8-4ed3-b85c-db6481800b50/

请参阅 Jamie Thomson 的回答及其后的回答.他们谈到始终使用默认代码页选项并解释如何找到它以及如何设置它.

See Jamie Thomson's answer and the one after it. They speak of the always use default code page option and explain how to find it and how to set it.

您也可以尝试使用适用于 Oracle 的 Attunity 连接器.我从来没有用过这个，但我听说过它很棒，它应该非常快:

You might also try the Attunity connector for Oracle. I have never used this one, but I have heard great things about it and it is supposed to be very fast:

http://www.microsoft.com/en-us/download/details.aspx?id=29284

这篇关于SSIS 2008 Oracle 连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！