title: Date format error ssis 2010 to excel 2013
body: <p>I have an SSIS 2010</p>
  
  <p>I have a Date formatted as 01/08/2016 in SQL Server 2012.</p>
  
  <pre><code>cast (DateColumn as Date) as DateColumn
  </code></pre>
  
  <p>but when this sent to and excel destination via SSIS is adding ' before the date as ... '01/08/2016  </p>
  
  <p>I have used a data conversion from the SSIS toolbox to  help it, but same happens </p>
  
  <p>any ideas please team to resolve this issue? </p>
  
  <p>please help</p>