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 – https://f5debug.net/tutorial/ssis.php
[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.