title: How can I extract values from a custom flat file header into variables?
body: <p>I have been stuck for a while with this problem and I have no clue. I am trying to upload multiple CSV files which has dates but I wanted the dates stored as date variables so I use the date variables to form part of the column in a table using script componet and I have no idea how to create the dates as date variables in SSIS.</p>
  
  <p>CSV files look as shown below when opened in Excel.</p>
  
  <h3>CSV data 1:</h3>
  
  <pre><code>Relative Date: 02/01/2013
  Run Date: 15/01/2013
  
  Organisation,AreaCode,ACount
  Chadwell,RM6,50
  Primrose,RM6,60
  </code></pre>
  
  <h3>CSV data 2:</h3>
  
  <pre><code>Relative Date: 14/02/2013
  Run Date: 17/02/2013
  
  Organisation,AreaCode,ACount
  Second Ave,E12,110
  Fourth Avenue, E12,130
  </code></pre>
  
  <p>I want the <em><code>Relative Date</code></em> and <em><code>Run Date</code></em> stored as date variables. I hope I made sense.</p>