title: SSIS data transfer slows down after inserting few million rows
body: <p>I am encountering this weird problem and any help will be really appreciated.</p>
  
  <p>I have a single container in which I have 2 data flow task in my SSIS package, data transfer is very huge. Breakdown of problem.</p>
  
  <ul>
  <li>First Container is transferring from oracle to SQL around 130 million rows and it ran just fine and transfer the rows in about 40 to 60 mins which is very much acceptable.</li>
  <li>Now come the second part another data flow task is there that is transferring around 86 million rows from SQL server to SQL server(one table) only, the data transfer flies very fast till 60 70 million and after that it just dies out or crawls just like anything for next 10 million rows it took 15 hours, I am not able to understand why is it happening so?</li>
  <li>Table get truncated and then it gets loaded, I have tried increasing DataBuffer proeprties etc but with no avail.</li>
  </ul>
  
  <p>Thanks in advance for any help.</p>