Import CSV File Error : Column Value containing column delimiter
<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>