.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

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

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

In this article we are going to see the different FTP task operations available in SQL Server Integration Services (SSIS). Before starting with the operations we will see on why are using the FTP Task operation
 

Introduction:

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


Steps:



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 Operation Task Operation Description
Send Files This operation is used to send some files to remote location
Receive files This operation is used to download some files from remote location
Create local directory This operation create a new folder on a local server
Create remote directory This operation create a new folder on the remote server
Remove local directory This operation delete a folder in the local server
Remove remote directory This operation delete a folder on the remote server
Delete local files This operation delete a file in the local server
Delete remote files This operation delete a file on the remote server

So 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 Operation Dynamic Properties
Send Files LocalVariable, LocalPath RemoteVariable and RemotePath
Receive files LocalVariable, LocalPath RemoteVariable and RemotePath
Create local directory LocalVariable and LocalPath
Create remote directory RemoteVariable and RemotelPath
Remove local directory LocalVariable and LocalPath
Remove remote directory RemoteVariable and RemotePath
Delete local files LocalVariable and LocalPath
Delete remote files RemoteVariable and RemotePath

 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