I also like the idea of utilizing a staging table to get your latest data into the database without interrupting data access.

Furthermore, you might consider using the MERGE INTO syntax...