Good old FTP and flat file import will do the trick reliably and never take a day off. Here are the basic steps to automate an FTP download in Windows followed by a CSV insert into MS SQL Server.

So you've been given a .CSV file from your HR department that contains a list of employees that you need create user accounts for in Active Directory. Perhaps it was because of a recent company merger ...