title: SSIS Derived Column
body: <p>I am not sure if the "Derived Column" transformation is my solution, but here is my issue. I am importing a CSV file and one of the column has data sorrunded by "'" e.g '2009-01-01' instead of 2009-01-01. Can I use the "Derive Column Transformation" to remove the single quotes? What would the expression be?</p>
  
  <p>Solution ~ Used the following expression in the "Derived Column Transformation"</p>
  
  <pre><code>REPLACE(['columnName'],"'","")
  </code></pre>