Export (0) Print
Expand All

File Transfer Protocol Task

SQL Server 2000

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. Files are transferred in binary mode only.

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

Enterprise Manager

See Also

DTSFTPTask Object

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
© 2015 Microsoft