title: SSIS - read a single header record from a flat file or an excel file prior to processing
body: <p>Is there a method by which one can read just the first record of a file, i.e., to read header information so that a decision can be made whther or not to process the remainder of the file?</p>
  
  <p>I know that with the split transformation component one can write an expression that will ignore all of the rows besides the header based on a key word in the header. I would rather not go that route as that is inefficiently reading every record in the file.</p>
  
  <p>Specifically, is there script component logic that I can implement to close the file
  and end the dataflow after the first record has been read?</p>