Step one is to fetch the latest data from another server via FTP. In Windows you can accomplish this using a script to send ftp commands. A simple example ... Flat File Import into SQL Server ...