title: Delete top row of excel file using SSIS
body: <p>I have an excel file that has a header row which is a row that I want to delete.  The header row in thsi file are the cells of A1 to W1 merged into one.  This causes a problem when I try to read the file because I am expecting column names.  Proper column names exist in the second row of the file, which is why I want to delete the first.</p>
  
  <p>To accomplish this I thought I'd be able to use the 'Excel Source' item in SSIS since it supports a SQL option to write a query.  What I want to do is something like this:</p>
  
  <pre><code>SELECT * from ExcelFile WHERE Row &gt; 1
  </code></pre>
  
  <p>My file only has data in columns A thru W.</p>
  
  <p>I don't know what syntax I can use in the query to do this.  The query builder that is in the Excel Source item will allow me to do many things with columns but I don't see an option for doing anything with rows.  Searching online and using the help didn't get me anywhere.  </p>