Usually it has become representable in terms of the flat file model used by SQL. Once this happens, the question is, “How can I get that data into the hands of as many people as possible?” ...

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.