I am presently doing this  - Use a SQL staging database that gets reloaded each night.  I then use DTS to load my Production SQL database with only the changes.  (This...