title: remove special characters " and ' from a column using SSIS
body: <p>I have a csv which has a column called "Value" and in it there are a combination of strings &amp; special characters.</p>
  
  <p>Eg:</p>
  
  <pre><code>Value
  abc
  xyz
  "
  pqr
  '
  </code></pre>
  
  <p>I want to replace the " and ' special characters with empty string "" in the output file.I used the derived column "Replace" function as </p>
  
  <pre><code>Replace(Replace(Value,"'",""),"\"","") 
  </code></pre>
  
  <p>and it doesn't seem to work</p>
  
  <p>tried this: in the derived column </p>
  
  <pre><code>Replace(Replace(Value,"'",""),"\"","")
  </code></pre>
  
  <p>I expect the output to be in a flat file with value column as</p>
  
  <pre><code>Value
  "abc"
  "xyz"
  ""
  "pqr"
  ""
  </code></pre>