The FTP Task gives us the ability to send files from a local system to a remote host or retrieve them from a remote host to a local system. There are other types of operations such as creating a remote folder or local folder. This task is very handy because FTP is in use between many companies for sharing their data. A company may export all its data into some CSV files, ZIP them and put them on an FTP address, and another company may need to get those files from FTP. The FTP Task also provides a way to work with multiple files.
Create new Integration Services project and name it
R03_FTP Task.In the package Control Flow, drag-and-drop an FTP Task and name it
FTP_ReceiveFiles.Double-click on FTP_ReceiveFiles to open the FTP Task Editor.
In the General tab of the FTP Connection property, create a new FTP Connection Manager. In the FTP Connection Manager Editor dialog window, type
ftp.microsoft.comin Server Name. Leave all other...