Sunday, October 7, 2012

Complete List Of Operations On FTP Task In SSIS


Introduction
This article provides complete information about  FTP Task operations and properties available in SSIS package.
Steps:
In this article we are going to see the different FTP task operations available. Before starting with the operations we will see on why are using the FTP Task operation. FTP task downloads and uploads some data file and manages servers on the remote server or even in the local server.
FTP Operations here means the list of operations the task supports in order to achieve some tasks like sending the file, receiving the file, looping through folder and selecting some files, looping through the folder and deleting some files, managing a directory etc.
Below table shows the list of operations available. 
Task Operation
Task Operation Description
Send Files
This operation is used to send some files to remote location
Receive files
This operation is used to download some files from remote location
Create local directory
This operation create a new folder on a local server
Create remote directory
This operation create a new folder on the remote server
Remove local directory
This operation delete a folder in the local server
Remove remote directory
This operation delete a folder on the remote server
Delete local files
This operation delete a file in the local server
Delete remote files
This operation delete a file on the remote server

How To Delete A Remote FTP Folder In SSIS

Introduction: This article provides complete information about how to delete a remote folder in ssis

simple 3 steps.
First create a simple project in BIDS. after creating a a project in SSIS we will see on how to use FTP task container. Drag and drop the FTP task as shown in the below screen.


clip_image001

Now double click on the task to open the property window and set the properties as shown in the below screen.