SSIS 2008 Oracle Connectivity

问题:

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 :

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 ?

回答1:

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

See the image here: Data Flow Component Properties

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

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.

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