title: Comma within fields in CSV file -import to DB using SSIS
body: <p>I have a CSV file - it has many values with comma as a part of them. The commas within the fields will mislead my SSIS package making it seem like the row has more columns than previously.</p>
  <p>How to resolve this?</p>
  <p>Eg:</p>
  <pre class="lang-none prettyprint-override"><code>Name,Amount,Address
  Me,20,000,My Home,India
  you,23,300,Your Home,Where
  </code></pre>
  <p>here only 3 columns exist but SSIS assumes all commas used to separate fields. However, that is not the case: Amount column and Address column have extra commas.</p>