title: SSIS : Flat File - value displays as
body: <p>I have an access DB. One column is of double-precision float format. Need to export these values to a Flat File.</p>
  
  <p>Scenario 1:</p>
  
  <p>MsAccess DB :  Column Value --> 12.34</p>
  
  <p>FlatFile : Column Value --> 12.34</p>
  
  <p>Scenario 2:</p>
  
  <p>MsAccess DB :  Column Value --> 12</p>
  
  <p>FlatFile : Column Value --> 12 instead want it to display as 12.00</p>
  
  <p>Solution Tried:
  1. Use Derived Column: added 0.001 now the value is 12.001, then using substring
  substring(columnName,1,5), now the value is 12.00.</p>
  
  <p>The problem is if the value is 120 or 1 then we will get 120.0 and 1.000.</p>
  
  <p>Also, when I use export to flat file in MsAccess, the flat files shows the values as 12.00.</p>
  
  <p>Is it possible to look for "."  and then skip the next two characters n delete the rest. If I convert the column to string type.</p>