早上有個朋友發郵件給遇到一個SSIS串連Oracle的問題，具體的錯誤資訊如下：
問題的原因：
1.因為BIDS是32位的應用程式即使在64位的機器上面，所以無法使用64位的.所以從64位的機器上串連Oracle無法成功。
2.因為
解決辦法如下：
- 11G full client.
- 32 AND the 64 bit version of the11G 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
