Search titles only By: Search Advanced search… ...

Note: For the purposes of today’s article, I will assume that you’re using SQL Server 2005 or later. Every SQL Server database has at least two files; a data file and a transaction log file.

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. To do this, we’ll use an SQL Server Agent Job.