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.

CSV files are used to import large amounts of data into various programs. Furthermore, most databases are able to export data -- such as stock inventories and client information -- as CSV files ...

How to open a .csv file in Excel Opening a .csv file is as easy as opening a .txt file, and usually, you won’t have to clean up the data before doing so because the save task inserts the delimiter.