title: Data Conversion text to numeric in SSIS is removing characters
body: <p>I am facing a strange issue while using SSIS &quot;Data Conversion component&quot; to convert string to decimal datatype. I use SSIS 2016.</p>
  <p>The source data input has values of mixed data types- string, integer, decimal and is defined as varchar in the flat file source. The target data type expected is numeric. When explicit type conversion happens from string to decimal, we expect the alphanumeric values to get rejected to error table and only the numeric values to pass through.
  Instead, we are seeing some alphanumeric values shedding the characters in the value and passing through successfully with no error.</p>
  <p>Examples: Value &quot;3,5&quot; converted to 35
  Value &quot;11+&quot; converted to 11</p>
  <p>We do not have control over source data and will not be able to replace char data before passing data into Data conversion component.
  We have tried the below steps as a workaround and it has worked.
  i.e,</p>
  <ol>
  <li>First Data Conversion from DT_STR to DT_NUMERIC</li>
  <li>Capture error rows that fail the above conversion</li>
  <li>Second Data Conversion from DT_NUMERIC to DT_DECIMAL</li>
  </ol>
  <p>But as the source data is not reliable, we may have to apply this workaround wherever there are numeric fields (int types &amp; deicmals) which is not a friendly solution.
  So checking with you all to understand if there is an easier and better solution tried out by anyone.</p>