When we want to work with Oracle in SSIS, we can use the Microsoft  Oracle Connector. It's better than other resource.

First we must download it here:

http://www.microsoft.com/en-us/download/details.aspx?id=29283

After we install it, we must add it to a list in SSIS.

Choose Toolbox Items-->SSIS Data Flow Items



Now we can use it in an SSIS package.

In the data flow, add the Oracle source and set config.

First we must create a connection to the Oracle database:

  

When you set the connection and test it, click OK. We can select your data:



Now you have data in the data  flow, and we can use it.

It is  for source Oracle and Oracle Destination.

Related topics to write about:
  • Dynamic query with an Oracle source.