Execute Oracle Insert statement in SSIS

Question

Hi All,

I have oracle source and destination tables and also I have insert statement (which dynamic dates in the where condition) which does the data extraction Oracle source and loads it to Oracle destination. I want to run oracle Insert statement in SSIS.

Please suggest the way.

Answer 1

Hi @RajKumar ,

You may use Microsoft OLE DB Provider for Oracle supported by Microsoft or Oracle Provider for OLE DB recommended by Microsoft to access the data in Oracle.

And then you may directly use the OLE DB Connection Manager for OLE DB Command to use the insert statement.

The following similar thread is for your reference:

https://stackoverflow.com/questions/5168772/update-a-row-in-oracle-using-oledb-commandssis

Regards，

Zoe

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

I want to run oracle Insert statement in SSIS.

And where is the problem doing so? I created several SSIS package accessing Oracle as source and destination; works fine.