If you’ve got several sources of data that you need to get into a database, you don’t have to get too fancy to automate the process. Good old FTP and flat file import ... a #Temp table to ...