How to Use Microsoft Oracle Source Component by Attunity

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:

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.

Additional resources