title: DT_Decimal Data Type Cutting off Decimal
body: <p>I have a flat file source that grabs a decimal value for the column Note Amount. The Source system specifies that this is a <code>DECIMAL(12,2)</code> file. I have the column in SSIS set to be <code>DT_Decimal</code></p>
  
  <p><img src="//i.stack.imgur.com/uCEpt.png" alt="File"></p>
  
  <p>The particular Flat file has a value of 122735.13 for one of it's amounts. However if I place a data viewer on the flow after the source it seems to be cutting the decimal off.</p>
  
  <p><img src="//i.stack.imgur.com/MgpOP.png" alt="DataFlow"></p>
  
  <p><img src="//i.stack.imgur.com/1h4cA.png" alt="ResultsCut"></p>
  
  <p>Any idea why this is happening? For reference I'm going to a <code>Decimal(12,2)</code> SQL Server 2012 Database.</p>