title: How to avoid 'number stored as text' error when exporting data from SQL server to excel (SSIS)
body: <p>This is what I am trying to do in the SSIS package:</p>
  
  <ol>
  <li>Copy blank excel sheet with headers as new file</li>
  <li>Run a data flow task populate data in the sheet.</li>
  <li>When a open the excel, all numeric data is shown with 'number stored as text' error.</li>
  </ol>
  
  <p>This stops all my charts from working. I would like to know how can I inform excel to treat the particular column data numeric.</p>