Floating FB popout byF5debug

SQL Server Integration Services (SSIS) – Part 26 – Delete remote folder using FTP Task in SSIS Package


This is part 26 of the series of article on SSIS. In this article we are going to learn how to delete remote FTP folder in SSIS.


In this article we are going to see on how to use a FTP task in SSIS package to delete a remote folder using FTP Task in SSIS packaging.

You can look into my series of article on SSIS at the url - http://f5debug.net/tutorial/ssis.aspx



Follow steps 1 to 3 on my first article to open the BIDS project and select the right project to work on integration services project. Once the project is created, we will see on how to use FTP task container. Drag and drop the FTP task as shown in the below screen.


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


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.


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.


So in this article we have seen on how to delete the folder in the remote server.

About Author: Karthikeyan Anbarasan, Microsoft MVP (Most Valuable Professional) in ASP.NET/IIS Architecture. He is the Founder and Chief Editor of the www.f5debug.net website and has authored books on Windows Phone and Business Intelligence(SSIS). He is also a Passionate Speaker and a Blogger on Microsoft Technologies.

You can Join Me On: Facebook, Twitter, Google Plus, LinkedIn

Add comment

  Country flag

  • Comment
  • Preview

Recent Posts

Random Posts

Most Viewed

URL Shortner

Create your own short urls!!!

Site Counter

free counters


This is a personal weblog. The opinions expressed here represent my own and not those of my employer. For accuracy and official reference refer to MSDN/ TechNet. I have documented my personal experience on this blog.

Protected by Copyscape Web Plagiarism Finder

Site Meter