Using Data Transformation Services, part 7: Transferring Files with DTS
(Page 1 of 4 )
File Transfer Protocol (FTP) is a custom task in SQL 2000 Server's Data Transformation Services. The files from an internet site can be transferred to a directory, or files can be transferred from one directory to another directory. This, in conjunction with the other DTS tasks discussed in the previous tutorials together with the workflow help in transferring the files easily.
FTP Task is used in replication for transferring snapshot files. This will be discussed in a forthcoming tutorial. For this tutorial, I will discuss very simple examples of FTP. These can performed in the DTS Designer discussed in earlier tutorials. Specifically, we will look at two of the allowed modes of transfer.
- From an internet FTP site to a directory on the hard drive
- From one folder to another in the same machine, or a to a shared drive
The FTP site Before you transfer files from a FTP site, you should gather some information about the site. In IIS 5.1 (as with the case of XP Professional), the IIS comes with Web sites, FTP sites, and a default SMTP Virtual Server site. For FTP purposes, we will configure the Default FTP site. A virtual directory XPHTEK_FTP has been added whose files will be stored in a directory C:\FTPSend on the hard disk, as shown in the following image. Further the authentication has been set to anonymous and does not require password.
The files and directories that are to be sent over FTP are stored in the C:\FTPSend directory. The (virtual directory) XPHTEK_FTP directory may be browsed to look at the contents as shown here.
Next: File Transfer From FTP Site to >>
More MS SQL Server Articles
More By Jayaram Krishnaswamy
