title: Error code: DelimitedTextMoreColumnsThanDefined Azure Data Factory
body: <p>I am trying to copy data from a csv file to a sql table in Azure Data Factory
  This is my type property for the CSV file</p>
  <pre><code>        &quot;typeProperties&quot;: {
              &quot;location&quot;: {
                  &quot;type&quot;: &quot;AzureBlobStorageLocation&quot;,
                  &quot;fileName&quot;: &quot;2020-09-16-stations.csv&quot;,
                  &quot;container&quot;: &quot;container&quot;
              },
              &quot;columnDelimiter&quot;: &quot;,&quot;,
              &quot;escapeChar&quot;: &quot;\\&quot;,
              &quot;firstRowAsHeader&quot;: true,
              &quot;quoteChar&quot;: &quot;\&quot;&quot;
  </code></pre>
  <p>I recieve following error:</p>
  <p><code>ErrorCode=DelimitedTextMoreColumnsThanDefined,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Error found when processing 'Csv/Tsv Format Text' source '2020-09-16-stations.csv' with row number 2: found more columns than expected column count 11.,Source=Microsoft.DataTransfer.Common,'</code></p>
  <p>This is row #2</p>
  <p><code>0e18d0d3-ed38-4e7f,Station2,Mainstreet33,,12207,Berlin,48.1807,11.4609,1970-01-01 01:00:00+01,&quot;{&quot;&quot;openingTimes&quot;&quot;:[{&quot;&quot;applicable_days&quot;&quot;:96,&quot;&quot;periods&quot;&quot;:[{&quot;&quot;startp&quot;&quot;:&quot;&quot;08:00&quot;&quot;,&quot;&quot;endp&quot;&quot;:&quot;&quot;20:00&quot;&quot;}]},{&quot;&quot;applicable_days&quot;&quot;:31,&quot;&quot;periods&quot;&quot;:[{&quot;&quot;startp&quot;&quot;:&quot;&quot;06:00&quot;&quot;,&quot;&quot;endp&quot;&quot;:&quot;&quot;20:00&quot;&quot;}]}]}&quot;</code></p>
  <p>I think the last column, the JSON query is making trouble in this case. When I view the data it looks fine:
  <a href="https://i.stack.imgur.com/V5Y6j.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/V5Y6j.png" alt="enter image description here" /></a></p>
  <p>I thought exactly the <code>&quot;quoteChar&quot;: &quot;\&quot;&quot;</code>would prevent that the last column makes problems. I have no idea why I am getting this error while i run debug</p>