title: Automatically Escape Quotes in SSIS Export
body: <p>I am using SQL Server 2014 with SSIS</p>
  
  <p>I have a data set like this:</p>
  
  <pre><code>ID   Name              Status
  1    Awesome "Store"   Active
  2    Market, Place     Active
  3    Vendor            Active
  </code></pre>
  
  <p>In SSMS, when the results are in the grid and I right click and choose save results as CSV, the raw output is this:</p>
  
  <pre><code>ID,Name,Status
  1,"Awesome ""Store""",Active
  2,"Market, Place",Active
  3,Vendor,Active
  </code></pre>
  
  <p>I need to use SSIS to export the data from the database to a CSV file so that the raw output is exactly the same as above. I do not want to do any derived columns to replace strings or anything that would be a custom solution for each time I need to do this for a new data set.</p>
  
  <p>I've tried using the flat file destination and setting the text qualifier to <code>"</code> but it puts quotes around every value (not a huge deal) but it does not escape the existing quotes in <code>Awesome "Store"</code> to <code>Awesome ""Store""</code> which is the main issue I am faced with.</p>
  
  <p>Does anyone have a solution that will achieve what I am looking for? Thanks!</p>