Those of you who has no other choice but running SSIS on 64 BIT ITANIUM which is not so nice..., should try this settings:
1. Install ORACLE (64-bit) 10.2.0.3 for Windows x64. (latest patch)
2. Define at the environment variable the path to ORACLE HOME .
3. If you had scripts written on 32BIT , you have to compile them on 64 bit, a typical workaround is to open them and define recompile=true on the target machine.
4. If the source table has a Numeric or Currency data type, try to transform them into string and then to the MSSQL correct data type.
Finally, don't give up during the process, there is a rumor that sql2K8 will have the driver!!!Stay tuned,