Also set the recovery model to simple. (maybe only during the load if you want point-in-time recovery during the rest of the day)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP