My example is not exactly fitting, but the automated
way helped the requirement of our client.

We have to upload data from one of our client who is running Tally,
and part of the data from his oracle database.
We convert the same to text file and load the same to Oracle.

We will load the same into a temporary table and convert the successful records to the main database, error records to another table, find and troubleshoot the errors and again
load the same to the main database.

This automation works fine (Only for inserts).