.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Articles >> DataBase >> Post New Resource Bookmark and Share   

 Subscribe to Articles

Delete local folder using FTP Task in SSIS Package - SQL Server Integration Services (SSIS)-Part 27

Posted By:Karthikeyan Anbarasan       Posted Date: April 13, 2011    Points: 200    Category: DataBase    URL: http://www.dotnetspark.com  

In this article we are going to see on how to use a FTP task in SSIS package to delete a local folder using FTP Task in SQL Server Integration Services (SSIS) packaging.
 

Introduction


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


Steps:


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 local box we need to set as below. Here input variable is used to get the path where we need to delete the folders locally.



Here once you have given valid credentials by running directly the package will do the necessary steps of deleting the folder in the local box using the FTP Task.

Conclusion

So in this article we have seen on how to delete the folder in the local machine.
 Subscribe to Articles

     

Further Readings:

Responses

No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply
Find More Articles on C#, ASP.Net, Vb.Net, SQL Server and more Here

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend