Reader Level:
ARTICLE

SQL Server Integration Services (SSIS) - Create remote folder using FTP Task in SSIS Package

On March 31, 2011 Articles | SQL Server
In this article you will see SQL Server Integration Services (SSIS) - Create a remote folder using FTP Task in SSIS Package.
  • 0
  • 0
  • 5736

Introduction


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

To follow my series of articles on SSIS packages refer to my profile for the links!!!

Steps:

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



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



The above image is for setting the FTP connection; the end user needs to provide the correct connection settings and can click on Test Connection to confirm that 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 it as below. Here an input variable is used to get the path that 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 how to create the folder in the remote server using the FTP Task.

Karthikeyan Anbarasan

Karthikeyan Anbarasan (Karthik) Microsoft MVP in ASP.NET/IIS Architecture is a blogger & Founder of www.F5debug.net, also he is a speaker and Technology geek in Microsoft products. Karthik is work...

Personal Blog: http://www.f5debug.net
  • 21rank
  • 1M readers
  • 1times
COMMENT USING

Trending up