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.

Learn how to install and configure SQL Server Management Studio, download a SQL Server, and connect them on a Windows 11/10/Server computer..

Figure 1. A SQL Server query against the Northwind database executed in PowerShell. (Click image to view larger version.) Fig. 2 is that same query as executed in SSMS (yes, I finally did get it to ...