且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

SSIS 2008 Oracle 连接

更新时间:2022-11-05 17:59:44

要使用原始提供程序,您只需指定代码页.我遇到过同样的问题.对于 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