Sunday, October 7, 2012

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.


clip_image002
The above image is for setting the FTP Connection, end user need to provide the correct connection settings and click on the Test Connection to confirm if the connection is valid.
Now in the file transfer tab we need to set the property since in our example we are going to delete a folder in the remote server we need to set as below. Here input variable is used to get the path where we need to delete the folders remotely.
clip_image003
Here once you have given valid credentials by running directly the package will do the necessary steps of deleting the folder in the remote server using the FTP Task.

No comments:

Post a Comment