File Transfer Protocol Task
The File Transfer Protocol (FTP) task lets you download data files from a remote server or an Internet location as part of a Data Transformation Services (DTS) package workflow. By including an FTP task, your DTS package can:
- Copy directories and data files from one server directory location to another, before or after performing data movement and transformations.
- Log in to a source FTP location and copy files or packages to a destination directory. The transformed data or package becomes available on an FTP site for download over the Internet, as part of the process of shipping the information to a data warehouse.
- Schedule the download of different files on a regular basis. By using the FTP task in conjunction with a Dynamic Properties task, you can change the names of files to be downloaded, according to properties you specify (for example, a date or the value of a run-time global or environment variable).
Note If you experience a problem using the FTP task, use ftp.exe in a command prompt to help identify the problem, as both the FTP task and ftp.exe use the same connection method.
To add a DTS task to a DTS package