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.

MS-SQL's bulk import tool counts the comma after the word "Some" as a delimiter which incorrectly increases the number of columns in the first data row from two to three. This tool is used to import ...