Data Pull from Oracle to Sql Server (4 million rows) Running on Windows

Thank you very much Ivan and Ipazin. I tried to increase the batch size writer to 10K and it did took significantly shorter time.

The read is still slow. Our datapipe is about 10Gb/s from our data center but it’s taking the same amount of time 3-4. i did change the configuration for fetch to 1000 but did not see it improve.

I wanted to update you so that you are aware.