title: Import CSV File Error : Column Value containing column delimiter
body: <p>I am trying to Import a Csv File into SQL SERVER using SSIS</p>
  
  <p>Here's an example how data looks like </p>
  
  <pre><code>Student_Name,Student_DOB,Student_ID,Student_Notes,Student_Gender,Student_Mother_Name
  Joseph Jade,2005-01-01,1,Good listener,Male,Amy
  Amy Jade,2006-01-01,1,Good in science,Female,Amy
  ....
  </code></pre>
  
  <p>Csv Columns are not containing text qualifiers (quotations)</p>
  
  <p>I Created a simple package using SSIS to import it into SQL but sometime the data in SQL looked like below</p>
  
  <pre><code>Student_Name    Student_DOB Student_ID  Student_Notes   Student_Gender  Student_Mother_Name
  Ali Jade    2004-01-01  1   Good listener   Bad in science  Male,Lisa
  </code></pre>
  
  <p>The Reason was that somtimes [Student_Notes] column contains Comma (,) that is used as  column delimiter so the Row are not imported Correctly </p>
  
  <p>Any suggestions</p>