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.

Note To bulk transfer data between multiple instances of [!INCLUDE ssNoVersion] by using a data file that contains extended or DBCS characters, you should use the Unicode native format. For more ...