title: BULK INSERT fails with row terminator on last row
body: <p>I'm importing a CSV compiled using cygwin shell commands into MS SQL 2014 using:</p>
  
  <pre><code>BULK INSERT import
  from 'D:\tail.csv'
  WITH (FIELDTERMINATOR = ',', ROWTERMINATOR = '\r', FIRSTROW = 1)
  GO
  </code></pre>
  
  <p>I have confirmed that each row contains a \r\n.  If I leave a CR/LF on the last row the bulk import fails with Msg 4832:</p>
  
  <blockquote>
    <p>Bulk load: An unexpected end of file was encountered in the data file.</p>
  </blockquote>
  
  <p>If I end the file at the end of the last data row then the bulk import succeeds.</p>
  
  <p>For very large CSVs a kludgy way around this problem is to find the number of rows and use the LASTROW setting for the BULK INSERT.  Is there a more graceful way to let MS SQL know that, yes, the last row is terminated and not to complain about it or fail on it?</p>