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

Karthikeyan Anbarasan
12y
11.4k
0
0

Article

Introduction

In this article we are going to see the different FTP Task operations available in SSIS package. To follow my series of articles on SSIS packages refer to my profile for the links.

Steps:

In this article we are going to see the different FTP task operations available. Before starting with the operations we will see 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.

The table shown below 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 requirements and makes use of them 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