You can save a backup of your MS SQL databases to a single file on your hard drive. These backup files have names ending with the ".bak" file extension, and you use them to restore database ...

Save that batch script with a .bat extension, ... Now that you’ve automated the fetching of your flat file via FTP, the next step is to automatically import that file into SQL Server.