title: SSIS Excel Destination Formatting
body: <p>I have an issue when attempting to write the results of 2 queries into 2 different sheets in a single Excel Workbook.  The job uses a template file which it copies into a date-stamped version.  The 2 sheets are named and pre-formatted with a header row.  The 2 queries are extracting data from the same table.</p>
  
  <p>The problem is as follows:</p>
  
  <p>The first query populates sheet1.  It skips a row after the headers and writes everything in unformatted text.</p>
  
  <p>The second query populates sheet2.  The data starts in the row immediately after the header, but for some reason all of the data picks up the formatting of the header row.</p>
  
  <p>One thing I've observed is that the order of processing determines which one has the formatting issue.  I have switched the order of the 2 Data Flow tasks around but it is always the second one to be processed that has the issue.</p>
  
  <p>I've linked to an image of some sample results.  </p>
  
  <p><img src="https://i.stack.imgur.com/39ZYq.png" alt="Sample Results"></p>
  
  <p>Thanks in advance for any suggestions you might have.</p>