title: Azure ADF Copy Activity with Trailing Column Delimiter
body: <p>I have a strange source CSV file where it contains a trailing column delimiter at the end of each record just before the carriage return/new line.</p>
  <p><a href="https://i.stack.imgur.com/zrryQ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/zrryQ.png" alt="FIRST_NAME,LAST_NAME,
  Christiana,Bellerose," /></a></p>
  <p>When ADF is previewing this data, it displays only 2 columns without issue and all the data rows.  However, when using the copy activity, it fails with the following exception.</p>
  <blockquote>
  <p>ErrorCode=DelimitedTextColumnNameNotAllowNull,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=The
  name of column index 3 is empty. Make sure column name is properly
  specified in the header</p>
  </blockquote>
  <p>Now I understand why it's complaining about this due to trailing delimiter, but my question is whether or not there is a way to deal with this condition?  I've tried including the trailing comma in the record delimiter (,\r\n), but then it just pivots the data where all the columns become rows.</p>
  <p>Is there a way to address this condition in copy activity?</p>