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.

1 shows a simple data flow that loads data from a flat file, called NewStores.txt, to a table in SQL Server called Stores ... text files are mapped. (Click image to view larger version.) ...