bulk insert : report row that failed

  • Thread starter Thread starter John A Grandy
  • Start date Start date
J

John A Grandy

Since I want BULK INSERT to fail on unique key violations , I set
MAXERRORS=0

But how to determine which row of the flat-file contains the duplicate ?

Apparently, ERRORFILE is not created for MAXERRORS=0
 
Back
Top