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.

Flat file databases A flat file database consists of one table. As a result, a large database will most likely have data which is unnecessarily repeated several times in the same table.

Usually it has become representable in terms of the flat file model used by SQL. Once this happens, the question is, “How can I get that data into the hands of as many people as possible?” ...