Continue the Copy and Log Errors
By using both LOG and ON_ERROR = CONTINUE in the clause, put invalid rows in a log file and continue to process valid ones. Correct the rows in the log file and load them into the database. For example:
copy table personnel
(name = char(0),
salary = char(0)nl)
from 'pers.data'
with on_error = continue,
log = 'badrows.data';