We are doing a basic ETL from Oracle to SQL Server using SSIS (Using a script component).
It is a basic read and bulk insert.
The insert is done in batches of 10,000.
When doing an ETL of 17million rows, we observe a steady decline in performance.
First batch taking 2 seconds but the last taking 132.
Any areas to look for solving?
Thanks

