Hi all,
I am trying to use bulk insert and to overwrite the primary keys in the table(destination) with the ones in the text file (source), I am setting the MAxErrors option to 9999, but I am always getting the following error:
"Violation of PRIMARY KEY constraint 'PK_Testingbulk'. Cannot insert duplicate key in object 'Testingbulk'.
The statement has been terminated."

I dont want this statment to be cancelled even if there is errors, and i think maxerror option is the way to do that but its not working.

thanx in advance.
Regards,