title: How do I fix the error that occurs during data transfer between SQL Server and MySql?
body: <p>I have an SSIS package that connects to a mysql server and attempts to pulls data from different tables and inserts the rows into a SQL Server 2005 database.</p>
  
  <p>One issue i notice is that at any given time it runs, regardless of what step it is on, it almost always fails to bring in the total records from mysql into sql server.</p>
  
  <p>there are no errors thrown. </p>
  
  <p>One morning it will have all 11M records and on the next run anywhere between 3K and 17K records.</p>
  
  <p>Anyone notice anything like this?</p>