SSIS – Connecting to 64-bit Oracle (2)
Here is an in-depth discussion about how to make SSIS work with 64-bit Oracle client.
Here is an extract from the above article. I’ll leave all these investigation/installation to our future DBA. For now, I’ll just use the linked server to work around this issue.