• SSIS is an ETL tool, so you would use it to copy data to and from Oracle. If what you want is to query data from Oracle, then you'll need a linked server or openquery, or openrowset.

    How to set up and troubleshoot a linked server to an Oracle database in SQL Server

    https://support.microsoft.com/en-us/kb/280106

    You can attempt using whatever client provider is already installed on your SQL Server machine, but if a client is needed for install, then you can use the Oracle Instant Client, which suits purpose for connectivity. There is no need to install the full Oracle client software.

    http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho