If my memory serves me right I think you need both 32- and 64-bit Oracle Client. If you're using BIDS (32-bit)you need 32-bit client to connect to the Oracle database. And a 64-bit client if SSIS is executed by SQL Server Agent (if you're running 64-bit SQL Server).