title: SSIS is dropping a record on flat file source import
body: <p>am experiencing a very strange issue in SSIS (2008).</p>
  
  <p>Basic workflow is as follows..</p>
  
  <p>Using a flatfile source (CSV), bring into SSIS, push into SQL.</p>
  
  <p><strong>When process is run on dev environment, everything works perfectly.</strong></p>
  
  <p>When the dtsx package is placed in production.. using the exact same flat file source, <strong>the last record in the file is dropped</strong> by the time it gets to the start of the SQL proc.</p>
  
  <p>Have gone over everything i can possibly think of including line delimiters, column delimeters, rebuilding the flat file source connection.</p>
  
  <p>Has anyone seen anything like this before?</p>
  
  <p>The CSV file contains 10 records and has 4 columns. It is comma delimited and line delimited by {CR}{LF}. The file was produced by Excel and has a blank line at the end of the CSV file.</p>
  
  <p>Let me know if more information is required. Im not sure what else i can offer.</p>