title: How to filter Flat File Source using script component
body: <p>I have the following scenario:
  I have thousands of text files with the below format.The column names are written in separate lines where as the row values are delimited by Pipe(|).</p>
  
  <pre><code>START-OF-FILE
  PROGRAMNAME=getdata
  DATEFORMAT=yyyymmdd
  
  #Some Text
  #Some Text
  #Some Text
  #Some Text
  #Some Text
  START-OF-FIELDS
  Field1
  Field2
  Field3
  ------
  FieldN
  END-OF-FIELDS
  TIMESTARTED=Tue May 12 16:04:42 JST 2015
  START-OF-DATA
  Field1Value|Field2value|Field3Value|...|Field N Value
  Field1Value|Field2value|Field3Value|...|Field N Value
  ------|...........|----|-------
  END-OF-DATA
  DATARECORDS=30747
  TIMEFINISHED=Tue May 12 16:11:53 JST 2015
  END-OF-FILE
  </code></pre>
  
  <p>Now I have a corresponding SQL Server table, where I can easily load the data as destination.
  Since I am new to SSIS, having trouble as to how to write the Script Component so that I can filter the Source Text files and easily load into sql server table.</p>
  
  <p>Thanks in advance!</p>