Hi I need some urgent  expert assistance please!
I have been doing research around and haven't come up with much...

Story: We are currently migrating a reporting server for a client which runs SQL 2005 on a Windows 2003 STD Server to SQL 2008 on Windows 2008 R2.
This has been all successful and we are in the middle of our testing phase.... But we do have a problem

The reporting server extracts it data from an Oracle 10 database
On the reporting server we have had to install the Oracle 11 Client
      - This is the only client we could find which supports being installed on
      - Our team believes that there should not be a problem with backwards compatibility (Oracle 11 Client accessing Oracle 10 DB)

The problem we are experiencing is when trying to connect SSIS packages to Oracle database.
It appears that the SSIS being a 32 bit application is not able to communicate with Oracle 11g (64 Bit) through Oracle Provider for OLE DB.

Through so browsing through the internet i came across this article - but not sure if this would be the best approach or suitable to our situation
http://blogs.msdn.com/b/jorgepc/archive/2008/02/12/ssis-error-dts-e-cannotacquireconnectionfromconnectionmanager-when-connecting-to-oracle-data-source.aspx 

So simply  The "Oracle OLE DB provider" is  not listed on the Native OLE DB on the Connection Manager.

Are there any Hot Fixes available ?
Any Ideas or thoughts - would be much appreciated it!!

Thank you in advance I leave it in your Expert Hands!!