There is another possibility.

Have two tables, t1 and t2, with identical structures.

t1 is your 'main' table. Assume that it is up to date with data.

On the next day, load table t2. Then use sp_rename to swap t1 and t2. And repeat ...