title: Determine ROW that caused "unexpected end of file" error in BULK INSERT?
body: <p>i am doing a bulk insert:</p>
  
  <pre><code>DECLARE @row_terminator CHAR;
  SET @row_terminator = CHAR(10); -- or char(10)
  
  DECLARE @stmt NVARCHAR(2000);
  SET @stmt = '
    BULK INSERT accn_errors
     FROM ''F:\FullUnzipped\accn_errors_201205080105.txt''
     WITH 
        (
          firstrow=2,
  FIELDTERMINATOR = ''|''  ,
  ROWS_PER_BATCH=10000
     ,ROWTERMINATOR='''+@row_terminator+'''
     )'
  exec sp_executesql @stmt;
  </code></pre>
  
  <p>and am getting the following error:</p>
  
  <pre><code>Msg 4832, Level 16, State 1, Line 2
  Bulk load: An unexpected end of file was encountered in the data file.
  Msg 7399, Level 16, State 1, Line 2
  The OLE DB provider "BULK" for linked server "(null)" reported an error. The provider did not give any information about the error.
  Msg 7330, Level 16, State 2, Line 2
  Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)".
  </code></pre>
  
  <p>is there a way to know on which ROW this error occurred?</p>
  
  <p>i am able to import 10,000,000 rows without a problem and error occurs after that</p>