Floating FB popout byF5debug

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

 

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.

Introduction

In this article we are going to see on the different FTP Task operations available in SSIS package.

You can look into my series of article on SSIS at the url - http://f5debug.net/tutorial/ssis.aspx

[more]

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

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

Conclusion

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

About Author: Karthikeyan Anbarasan, Microsoft MVP (Most Valuable Professional) in ASP.NET/IIS Architecture. He is the Founder and Chief Editor of the www.f5debug.net website and has authored books on Windows Phone and Business Intelligence(SSIS). He is also a Passionate Speaker and a Blogger on Microsoft Technologies.

You can Join Me On: Facebook, Twitter, Google Plus, LinkedIn

Add comment

  Country flag

biuquote
  • Comment
  • Preview
Loading

Recent Posts

Random Posts

Most Viewed

URL Shortner

Create your own short urls!!!

Site Counter

free counters

Disclaimer

This is a personal weblog. The opinions expressed here represent my own and not those of my employer. For accuracy and official reference refer to MSDN/ TechNet. I have documented my personal experience on this blog.

Protected by Copyscape Web Plagiarism Finder

Site Meter