Dump everything first in staging table which all columns as varchar. Post that each column must be validated via Data conversion and set the error output as desired.