title: Why does my excel plus source in ssis outputting a fixed one date for all date columns?
body: <p>I have an excel file that I want to import using SSIS, I have done this process many more times without a problem with other excel files. however, this excel file has three spreadsheets on it. two of them works just fine importing correct data, BUT one of them is importing fixed data with <code>06-30-2019</code> for all date fields, and this not changing when it gets to table but it changed while it still at the source when I preview it, I see a fixed date already set up for date fields but other fields that are non-date fields are coming good.  the dates in the spread field of that sheet have different dates per row for that field/column. how is this happening? I am using SSIS 2017 and excel plus loads to table SQL 2017. how can I fix this? </p>
  
  <p>in my excel sheet1</p>
  
  <pre><code>col1  datefield
  1     01-08-2019
  2     05-06-2019
  3     06-12-2019
  4     07-25-2019
  </code></pre>
  
  <p>in my excel source SSIS on preview show this below and that what it loads as well to table.</p>
  
  <pre><code>col1  datefield
  1     06-30-2019
  2     06-30-2019
  3     06-30-2019
  4     06-30-2019
  </code></pre>