Another approach is to use views to alternate source tables by updating the view at the end of the load procedure to point at the last updated table. ...

Sometimes the easiest way is not the most elegant. When I just have one set of duplicates I select the date, stash it on a nopepad or excel, delete...