FTP Task

The FTP task downloads and uploads data files and manages directories on servers.

You can use the FTP task for the following purposes:

Ø  Copying directories and data files from one directory to another, before or after moving data, and applying transformations to the data.

Ø  Logging in to a source FTP location and copying files or packages to a destination directory.

Ø  Downloading files from an FTP location and applying transformations to column data before loading the data into a database.

Double click on the FTP task you will get the FTP Task Editor.

Click on the FTP connection you will get the following FTP connection Manager Editor.

Server name: - ftp.microsoft.com

Server port: - 21

This is free FTP server. Click on the Test Connection. You will get the conformation like connection successfully.

File Transfer

We can do the following operation in file transfer

Ø  Send File

Ø  Receive Files

Ø  Create local directory

Ø  Create remote directory

Ø  Remove local directory

Ø  Remove remote directory

Ø  Delete local files

Ø  Delete remote files.