title: SSIS (C# or VB): delete rows 1-12 in all excel files in directory
body: <p>Before importing data from multiple excel files I need to get rid of first 12 rows in each worksheet. I am going to use <a href="https://drive.google.com/file/d/0B-RENjpYfc0fX3RhZkx2X2FjQnM/view" rel="nofollow noreferrer">the code</a> from <a href="http://www.techbrothersit.com/2016/03/how-to-load-excel-file-name-and-sheet.html" rel="nofollow noreferrer">this solution</a> for bulk processing script task.</p>
  
  <p><strong>Questions:</strong></p>
  
  <ul>
  <li>What code should I insert into the script to delete rows? (I suppose right after <code>//Load the DataTable with Sheet Data so we can get the column header</code>); or</li>
  <li>How to modify this code to make it read excel files starting from Row 13; or,  alternatively</li>
  <li>What SSIS task should I insert before the script for bulk row deletion? </li>
  </ul>