I have trying to setup SSIS package, Here is my requirement,
I need to move data from a Oracle View to a oracle table and move data oracle table to SQL Table for further processing.
If I pull data from Oracle view (joining around 18 tables) takes more time to read from Oracle to insert into SQL Server. To avoid timing's , I am thinking to insert data from Oracle view into Oralce table and then table to SQL Server.
If I move data from Oracle view to Oracle table and this task is called from SSIS, Is this data movement is local to oracle or move across network.
View Complete Post