SQL Server Integration Services (SSIS) – Part 21 – FTP Task Operations in SSIS Package.

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

This is part 21 of the series of article on SSIS. In this article we are going to see know about different FTP tasks operations available in SSIS.


In this article we are going to see on the different FTP Task operations available in SSIS package. To follow my series of articles on SSIS packages refer to the below URL’s


In this article we are going to see the different FTP task operations available. Before starting with the operations we will see on why are using the FTP Task operation. FTP task downloads and uploads some data file and manages servers on the remote server or even in the local server.

FTP Operations here means the list of operations the task supports in order to achieve some tasks like sending the file, receiving the file, looping through folder and selecting some files, looping through the folder and deleting some files, managing a directory etc.

Below table shows the list of operations available.

Task OperationTask Operation Description
Send FilesThis operation is used to send some files to remote location
Receive filesThis operation is used to download some files from remote location
Create local directoryThis operation create a new folder on a local server
Create remote directoryThis operation create a new folder on the remote server
Remove local directoryThis operation delete a folder in the local server
Remove remote directoryThis operation delete a folder on the remote server
Delete local files This operation delete a file in the local server
Delete remote filesThis operation delete a file on the remote server

S0 based on these task operations we need to select the best which suits our requirement and make use of it based on the configuration. The dynamic operation properties available for each of these task operations are as follows

Task OperationDynamic Properties
Send FilesLocalVariable, LocalPath RemoteVariable and RemotePath
Receive filesLocalVariable, LocalPath RemoteVariable and RemotePath
Create local directoryLocalVariable and LocalPath
Create remote directoryRemoteVariable and RemotelPath
Remove local directoryLocalVariable and LocalPath
Remove remote directoryRemoteVariable and RemotePath
Delete local files LocalVariable and LocalPath
Delete remote filesRemoteVariable and RemotePath


So in this article we have seen on the list of operation available for the FTP task and the properties of each operation.

Page copy protected against web site content infringement by Copyscape

About the Author

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 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)