DTS Import File Advice Needed

Hi,

Basically I just need some advice. I am using DTS to import a CSV file into my database. This import will take place each day, as a scheduled task. This import will need to totally replace what was in the table before (delete data in the table and then import the csv).

The bit I need advice on though is, I want to run some checks on the data that is being imported before it is commited. If there are any errors or probs then i want to just keep the data as it was the day before (ie. don't commit the new data). What is the best way to do this? I was thinking along the lines of creating a 2nd table, which i first import the data to, run the checks on it (like row count etc) and then if all OK, copy this table into the final table. If there are any errors or the checks highlight a prob then this final copy will not take place, therefore leaving the data as it was the day before.

Or is there a better (simpler / more efficient) way to do it?

Cheers.