• OPC has got it. An SQL Server Agent job with BCP is definately the answer.

    If however you have an Express version, I would recommend creating an OS-level Batch Job that calls BCP and then running the batch using Windows Scheduler.