title: Can't convert DT_NTEXT to NUMCERIC using SSIS
body: <p>we load a CSV from the web via Power Query. Among other columns there are three money columns with the data type DT_NTEXT as output column. I have already tried to use a data conversion task as first thing to convert the columns to DT_WSTR(4000) and then convert them to numeric(17,5) in a following Derived Column Task with the following expression:</p>
  <pre><code>TRIM(price_conv) == &quot;&quot; ? NULL(DT_NUMERIC,17,5) : ((DT_NUMERIC,17,5)TRIM(price_conv))
  </code></pre>
  <p>Unfortunately, this still fails.</p>
  <p>Error messages:</p>
  <blockquote>
  <p>[Derived column [2]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR.  The &quot;Derived column&quot; failed because error code 0xC0049063 occurred, and the error row disposition on &quot;Derived column.Output[Output of the Derived column].column[price_derived]&quot; specifies failure on error. An error occurred on the specified object of the specified component.  There may be error messages posted before this with more information about the failure.</p>
  <p>[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED.  The ProcessInput method on component &quot;erived column&quot; (2) failed with error code 0xC0209029 while processing input &quot;Inputof the derived column&quot; (3). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running.  There may be error messages posted before this with more information about the failure.</p>
  </blockquote>
  <p>PS: Error messages partly translated from German.</p>
  <p>I also tried to set DT_WSTR in the advanced editor of the Power Query source, but it failed as well.</p>
  <p>Does anyone have an idea?</p>