title: BULK INSERT fails with last row
body: <p>I'm importing a CSV using sql server bulk option and below is my sql inputs.</p>
  
  <pre><code>MAXERRORS = 1000000,
  CODEPAGE = 1251,
  FIELDTERMINATOR = '~%',
  ROWTERMINATOR = '0x0a',
  ERRORFILE = 'C:\MyFile_BadData.log'
  </code></pre>
  
  <p>My problem is BULK INSERT fails to load the last row data. </p>
  
  <p>Also please note that no errors was reported by the sql bulk option..</p>
  
  <p>If i add a empty newline to the file the loading works without any issues. </p>
  
  <p>But my concern is i cannot modify the CSV file, please suggest your valuable inputs if any</p>