title: Mysql to mssql Data Load failure - High number of rows
body: <p>I have an SSIS package connecting to a MYSQL system and fetching data within a table. As a One time Load, i need to fetch 570,000,000 rows into this table. This package keeps timing out and currently, i have 0 records imported.</p>
  
  <p>I tried breaking it into 10 chunks of 57,000,000 each using value in an incremental id column. it does'nt help. How can i find an optimum count of data that can be imported in one go. </p>
  
  <p>How can I import all rows efficiently, given an Id field which is auto- increment? It is only a one time operation.</p>