title: A 99.99 numeric from flat file doesn't want to go in a NUMERIC(4,2)'SQL Server
body: <p>I have a csv file :</p>
  
  <pre><code>1|1.25
  2|23.56
  3|58.99
  </code></pre>
  
  <p>I want to put this value in a SQL Server table with SSIS.
  I have created my table :</p>
  
  <pre><code>CREATE TABLE myTable( ID int, Value numeric(4,2));
  </code></pre>
  
  <p>My problem is that I have to create a Derived Column Transformation to specify my cast :</p>
  
  <pre><code>(DT_NUMERIC,4,2)(REPLACE(Value,".",","))
  </code></pre>
  
  <p>Otherwise, SSIS don't seem to be able to put my Value in my column, and fill my column with null value.</p>
  
  <p>And I think it is tooooo ugly to do it this way. I want my Derived Column Transformation be here for real new derived column, and not some simple cast that I think SSIS have to detect.</p>
  
  <p>So, what is the standard way to use SSIS to resolve this problem ?</p>