T-SQL：如何在导入期间记录错误的条目

I do an import and convert columns to other datatypes. During the import I check, if I can convert the values stored in the columns into the target datatypes. If not I put a default value, e.g. I convert a string to int and when I cannot convert the string I insert -1.I do an import and convert columns to other dat