Here are the basic steps to automate an FTP download in Windows followed by a CSV insert into MS SQL Server. ... Save that batch script with a .bat extension, like GetCSV.bat.