title: Reading a csv file, ignoring some rows in the middle
body: <p>I'm trying to use SSIS to import a csv file. Normally it works fine, but the file in question has this format:</p>
  
  <blockquote>
    <p>....<br>
    data, data, data, data, data, data, data<br>
    ignore, ignore<br>
    ignore, ignore<br>
    ignore, ignore<br>
    data, data, data, data, data, data, data<br>
    ...</p>
  </blockquote>
  
  <p>The result is that it imports the <code>data</code> ok, but when it gets to the <code>ignore</code> lines, it'll start putting the next line of data as the rest of the expected columns until it encounters a newline.</p>
  
  <p>How can I ignore the rows that don't have the required number of fields?</p>
  
  <hr>
  
  <p>I'm using SSIS 2005.</p>