title: SSIS 2008 R2 - How to load header and data row from CSV
body: <p>I have a CSV file where there is a header row and data rows in the same file.</p>
  
  <p>I want to get information from both rows during the same load.</p>
  
  <p>What is the easiest way to do this?</p>
  
  <p>i.e File Example - Import.CSV</p>
  
  <p>2,11-Jul-2011
  <br>Mr,Bob,Smith,1-Jan-1984
  <br>Ms,Jane,Doe,23-Apr-1981</p>
  
  <p>In the first row, there a a count of the number of rows and the date of transmission.</p>
  
  <p>In the second and subsequent rows is the actual data, in this Title, FirstName, LastName, Birthdate</p>