title: stuck with data conversion SSIS
body: <p>I'm stuck with a conversion problem...or atleast at datatype problem.
  Trying to read a csv-file and update a SQL-database with its content.
  The column I have problems with have numbers like 64,51 (at most 3 digits with 2 decimals).</p>
  
  <p>In the database I have set the datatype as decimal(3,2) and in the flat file Connection manager I have set it as decimal(DT_DECIAL) with the scale of 2.
  Along the flow I do a Derived column, merging two columns into one and then convert the new column.</p>
  
  <p>Looking in the advanced editor of the OLE DB-destination I can see that in the Input Columns the column is set as DT_DECIMAL, but in the External column its set as a DT_NUMERIC.
  How do I change that?
  I can change the properties but every time it reverts back to numeric when I press OK.</p>
  
  <p>The errormessage says: "Conversion failed because the data value overflowed the specified type."</p>
  
  <p>Thanks for all tips on this!</p>