Consider staging tables for importing data without performing the data validation initially, but doing it as a two step process, where the second step reads the data from the staging tables and validates it before writing it to the primary tables. This process would be smart enough to track and manage what staging table rows have been written to the primary tables.
