title: SSIS Expression in a Derived Column Transformation to replace a carriage return with nothing
body: <p>I am using SQL Server 2005 SSIS and am importing a <code>text file</code> that has carriage return<code>enter code here</code> at the end of each line I am then casting the value. </p>
  
  <pre><code>(DT_NUMERIC,28,8)(ISNULL(MyField) ? NULL(DT_WSTR,50) : 
  REPLACE(MyField,"Carriage Return Value",""))
  </code></pre>
  
  <p>In the place of <code>Carriage Return Value</code> I have tried: </p>
  
  <pre><code>CHAR(13) + CHAR(10), "\r\n", "\""
  </code></pre>
  
  <p>But these wont work or give errors.</p>
  
  <p>Thanks in advance</p>