When SSIS is connected to Oracle, the following error occurs: These components are supplied by Oracle Corp.

In the morning, A friend sent an email to a SSIS connection to Oracle. The specific error message is as follows:

 

 

Cause:

 

1. Because BIDS are 32-bit applications, even on 64-bit machines, they cannot use 64-bit applications. Therefore, connection to Oracle from 64-bit machines fails.

 

2. Because

 

The solution is as follows:

• 11G fullClient.
• 32 AND the 64 bitVersion of11G fullClient (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.

 

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