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.

When it comes to handling large volumes of data in SQL Server—especially importing and exporting flat files like CSVs or TXT files—the BCP (Bulk Copy Program) utility is one of the most powerful tools ...

The File Server Resource Manager is not installed by default in Windows Server 2012 and 2012 R2. To install it, you must open the Server Manager and choose the Add Roles and Features command from ...

You can use one of two options to insert CSV files: "Bulk Insert," a command that works from the SQL Server Management Studio, or "bcp utility," which you run from a Windows command line prompt.