SSIS 连接Oracle报错 These components are supplied by Orac

SSIS 连接Oracle报错 These components are supplied by Oracle Corporation and are part of the Oracle Versi

早上有个朋友发邮件给遇到一个SSIS连接Oracle的问题，具体的错误信息如下：

问题的原因：

1.因为BIDS是32位的应用程序即使在64位的机器上面，所以无法使用64位的.所以从64位的机器上连接Oracle无法成功。

2.因为

解决办法如下：

• 11G full client.
• 32 AND the 64 bit version of the 11G full client (Installation Type: Administrator) and reboot the server afterwards. The 32 bit version is needed for development from BIDS with is 32 bit, the 64 bit version is needed for production with the SQLAgent, which is 64 bit.
• Oracle provider for OLE DB" from SSIS, don't use the "Microsoft Provider for Oracle" because a 64 bit version of it does not exist.

HKEY_LOCAL_MACHINE\Software\Microsoft\MSDTC\MTxOCI      
Make sure the following values are entered:

HKEY_LOCAL_MACHINE\Software\Wow6432Node\Microsoft\MSDTC\MTxOCI       
Make sure the same values as above are entered.

来源于：http://sqlblog.com/blogs/jorg_klein/archive/2011/06/09/ssis-connect-to-oracle-on-a-64-bit-machine.aspx