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.

SQL Server keeps a buffer of all of the changes to data for performance reasons. It writes items to the transaction log immediately, but does not write changes to the data file immediately.

/PRNewswire/ -- Data Sciences Corporation, a thought leader in delivering innovative datacenter solutions across South Africa has joined the DH2i DxAdvantage ...