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

KarthikAnbarasan
Posted by in Sql Server category on for Intermediate level | Points: 250 | Views : 7582 red flag

This is part 28 of the series of article on SSIS. In this article we are going to learn how to create remote FTP folder using SSIS.

Introduction


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

To follow my series of articles on SSIS packages refer to the below URL’s

SSIS Series Part 1 to 27

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 create 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 create the folder in the remote server.



Here once you have given valid credentials by running directly the package will do the necessary steps of creating a new directory in the remote server using the FTP Task.

Conclusion


So in this article we have seen on how to create the folder in the remote server using FTP Task.

Page copy protected against web site content infringement by Copyscape

About the Author

KarthikAnbarasan
Full Name: Karthikeyan Anbarasan
Member Level: Silver
Member Status: Member,Moderator,Microsoft_MVP,MVP
Member Since: 1/2/2011 3:00:14 AM
Country: India
Thanks Karthik www.f5Debug.net
www.f5Debug.net
www.f5Debug.net Around 5 years of experience in Microsoft technologies like ASP.Net, VB.Net, C#.net, SQL server, Biztalk Server, WCF, WPF, SSIS, SSRS, SSAS, AJAX and working as Senior Analyst in a US based MNC.

Login to vote for this post.

Comments or Responses

Login to post response

Comment using Facebook(Author doesn't get notification)