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 ... create a new SQL Server ...

Select a SQL Server computer entry in the "Connect to Server" dialog. Set the Authentication pull-down list to "Windows Authentication" and click the "Connect" button. Click "New Query" in the ...