title: SSIS Text Qualifier not working correctly
body: <p>I have a CSV file I am importing through SSIS.Below is an sample of the data in my file</p>
  
  <p>"MEM1001","OTHER","P" ,20101001,20781231,,20781231,20101001,
  "Medic","General >21"                               ,
  "A100100"                   ,"2210",20101001,20781231</p>
  
  <p>I have added , as column delimiter and " as Text Qualifier in the connection manager.</p>
  
  <p>But columns like "P" ,"Medic","General >21"                               ,"A100100"                   ,  are still coming enclosed with double quotes when I preview the data while rest the of the string columns are coming without double quotes.
  I am guessing it has something to do with the spaces after the quotes.</p>
  
  <p>Can somebody explain why this is happening and how can i make this columns to come without double quotes while importing the data from file to table.</p>