title: Removing commas and quotes from numeric fields in csv file using SSIS
body: <p>I am creating SSIS package which reads data from a csv file and stores in SQL Server database. There are a few numeric fields in the csv files.
  They sometimes contain value like <strong>"1,008.54"</strong></p>
  
  <p>How do I remove the quotes and comma from the value?</p>
  
  <p>I have successfully separated the rows with this kind of data by using <strong>Conditional Split Transformation</strong>.
  (SUBSTRING([Column 9],1,1) == "\"")</p>
  
  <p>After this, I tried using <strong>Derived Column Transformation</strong> to REPLACE comma and quotes with empty string. But it is not working.</p>
  
  <p>Please advise.</p>
  
  <p>Thanks!</p>