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.

How to Import an XML File Into Google Docs. Originally introduced in 2006, Google Docs has continued to grow in its support of various document formats, including XML.

This tells the request how to authenticate against the FTP server. The URI provided to the request object will include the file name you want to upload or download.