scenario to update or insert big amount of data
I would do it like this:

Load all data into an empty staging table and use SQL to identify and correct problematic records before moving the data into your database.