We are trying to implement an automatic process that will import into IC unattended overnight. So, deleting the row manually is not an option either.

Even when validation is not used, the process stops to inform that there is a corrupted row and need manual intervention.