I have a bulk insert command which works great but I need to clear out my tables every night and reload using the bulk insert command from tab delimitted files which I pick up every night. The files are dumped into a directory on my windows box.
How do I schedule sql commands like this to run overnight, can I create a .sql command file and just bung it in Windows task scheduler? Does sql server have some sort of task scheduler built in for this kind of thing? Any pointers much appreciated!