Perhaps it could be enough to install the Oracle Data Access Components (ODAC) for Windows and not an Oracle client, isn't it?

However, it should be useful to know any Microsoft articles that talks about how using the Oracle data provider inside SSIS without studying Oracle documentation.

I think that this issue is common for more other developers. It is enough only setting the TSNAMES ...