title: SQL SSIS Export to Excel, Casting the Decimal Values
body: <pre><code>Select CAST (ROUND (t_paid,2) as numeric(36,2)) as [Copay] from Sales
  
  Select CAST (ROUND (t_paid,2) as decimal(18,2)) as [Copay] from Sales
  </code></pre>
  
  <p>From the SQL, I can see the output values as <strong>0.00</strong> </p>
  
  <p>I am exporting this to a Spreadsheet (.xls ) format. In the Excel Sheet, i am getting the value as 0.</p>
  
  <p>As per the requirement, i need to get all whole numbers as 0.00 or 1.00.</p>
  
  <p>How to cast the values while exporting to excel in the SSIS Package ??</p>