Download and install the oracle 64 bit driver (v10.2.0 i think) onto your sql server machine.

On your client machine\workstation install the Oracle 10g 32 bit driver (v10.2.0)

This will work as we have a dev team that connects to oracle and pulls it to Sql Server.

Don't use the Oracle 9i drivers as SSIS BIDS enviroment does not like them