title: Why does SSIS Excel Source doesnt read empty columns?
body: <p>I have a calendar table Excel file. Every month a new column is added.</p>
  
  <p>I shouldn't read columns names. When I developed ETL in May, I placed dummy columns until December. The Excel file was like this (columns):</p>
  
  <pre><code>customer  jan12  feb12  mar12  apr12  may12
  </code></pre>
  
  <p>To form metadata data in ETL I added dummy columns until December:</p>
  
  <pre><code>customer jan12 feb12 mar12 apr12 may12 mon mon mon mon mon mon mon
  </code></pre>
  
  <p>Then in SSIS Excel Source I wrote a query:</p>
  
  <pre><code>select * from Sheet1$A2:M1624
  </code></pre>
  
  <p>(not reading column names and reading until dec column)</p>
  
  <p>Now in June the Excel file came like this:</p>
  
  <pre><code>customer jan12 feb12 mar12 apr12 may12 jun12
  </code></pre>
  
  <p>Since I created metadata, I thought load will be peaceful. To my fate ETL failed.</p>