title: SSIS Derived Column Rounds Values
body: <p>One of the columns I am selecting in an SSIS query, <code>TransTotal</code>, has values like this:</p>
  
  <pre><code>----
  4615
  3845
  8706
  8725
  4205
  ----
  </code></pre>
  
  <p>I my derived column, I need to insert a decimal, so I have added this expression:</p>
  
  <pre><code>(DT_NUMERIC,10,2)(TransTotal / 100)
  </code></pre>
  
  <p>Expecting the results to look like:</p>
  
  <pre><code>-----
  46.15
  38.45
  87.06
  87.25
  42.05
  -----
  </code></pre>
  
  <p>But instead, they look like:</p>
  
  <pre><code>-----
  46.00
  38.00
  87.00
  87.00
  42.00
  -----
  </code></pre>
  
  <p>What am I doing wrong?</p>