Task Factory Loews Corporation
"We bought the product mostly because of the company's reputation for the service they provide and the specific need of a secure SFTP task."

Matt Cushing

Application Systems Analyst/Developer

Loews Corporation

Greater New York City Area

Read More
Task Factory - Mark Marinovic
"We bought Task Factory primarily for the SCD Type 2 task, as it enabled us to do several things the built-in SSIS SCD task did not do. Task Factory comes highly recommended from me as our ROI was reached in just days."

Mark Marinovic

Read More
Task Factory - Urban Outfitters
"We have found that Task Factory tremendously speeds up the development process and improves performance by means of the high-performance components."

Tim Harris

BI Data Engineer

Urban Outfitters Inc.

Read More


Buy Now Free Trial Download Compare Editions
Task Factory Secure FTP Task

Brings encrypted security to FTP within SSIS. Many companies transmit files using FTP as a transmission method for highly sensitive files. The Task Factory Secure FTP Task will allow you to transmit files over most common secure channels to your partners safely.

Feature Highlights

  • Used to interact with a secure FTP site 
  • Supports SSH, Implicit SFTP and Explicit SFTP 
  • Supports HTTP, SOCKS4, SOCKS4a and SOCKS5 proxies 
  • Supports all actions provided by native FTP task
  • Easy to use User Interface
Secure FTP Task

Secure FTP Task- Step 1
The easy to use UI of the Secure FTP (SSIS FTPS / SFTP) Task allows the user to quickly connect to an SFTP server and start using SFTP within SSIS in a matter of minutes. Here is an overview on how to configure the Secure FTP Task (SSIS FTPS / SFTP). 

The easy to use UI of the Secure FTP (SSIS FTPS / SFTP) Task allows the user to quickly connect to an SFTP server and start using SFTP within SSIS in a matter of minutes. Here is an overview on how to configure the Secure FTP Task (SSIS FTPS / SFTP). 

Secure FTP Task- Step 2
Task Settings
  • What will this task do - Select what action the Secure FTP Task (SSIS FTPS) will perform. 
  • Stop package on failure - If this option is selected on the Secure FTP Task (SSIS FTPS) and the action selected fails to complete successfully then the SSIS package will fail.


Task Settings
  • What will this task do - Select what action the Secure FTP Task (SSIS FTPS) will perform. 
  • Stop package on failure - If this option is selected on the Secure FTP Task (SSIS FTPS) and the action selected fails to complete successfully then the SSIS package will fail.


Secure FTP Task- Step 3
Local Directory or File Settings
In this section, the local directory or file being used as part of the Secure FTP Task (SSIS FTPS) is defined. This setting can point to a file or directory depending on what action is selected.
  • Unavailable for "Create directory on server", "Delete directory on server", "Delete file on a server" and "Check if file exists on server"
  • Local path stored in a variable - Selecting this option will change the "Local connection manager" to "Select local variable" and change the drop down from a list of connection managers to a list of user string variables available in the package. 
  • Local connection manager - Available when "Local path stored in a variable" is unchecked. The drop down will contain any connection managers with a type of FILE and FLATFILE.
The local connection manager or variable for the local path of the SSIS FTPS can be set in the task expression as well.

Local Directory or File Settings
In this section, the local directory or file being used as part of the Secure FTP Task (SSIS FTPS) is defined. This setting can point to a file or directory depending on what action is selected.
  • Unavailable for "Create directory on server", "Delete directory on server", "Delete file on a server" and "Check if file exists on server"
  • Local path stored in a variable - Selecting this option will change the "Local connection manager" to "Select local variable" and change the drop down from a list of connection managers to a list of user string variables available in the package. 
  • Local connection manager - Available when "Local path stored in a variable" is unchecked. The drop down will contain any connection managers with a type of FILE and FLATFILE.
The local connection manager or variable for the local path of the SSIS FTPS can be set in the task expression as well.

Secure FTP Task- Step 4
Remote Connection and Directory or File Settings

In this section, the remote directory or file being used as part of the Secure FTP Task (SSIS FTPS) is defined. This setting can point to a file or directory depending on what action is selected. 

  • SFTP Connection Manager - Select an existing SFTP Connection Manager or create a new one. The Secure FTP Task (SSIS FTPS) supports creating a new connection from within the UI.
  • Remote path stored in a variable - Selecting this option will change the textbox below the checkbox to a drop down filled with local user string variables.

Remote Connection and Directory or File Settings

In this section, the remote directory or file being used as part of the Secure FTP Task (SSIS FTPS) is defined. This setting can point to a file or directory depending on what action is selected. 

  • SFTP Connection Manager - Select an existing SFTP Connection Manager or create a new one. The Secure FTP Task (SSIS FTPS) supports creating a new connection from within the UI.
  • Remote path stored in a variable - Selecting this option will change the textbox below the checkbox to a drop down filled with local user string variables.

Secure FTP Task- Step 5
  • Directory location on server, Directory on server to upload file, File to download from server, Directory to create on server, Directory to delete on server, File to delete from server, File to check on server - Depending on what action is selected, this option is used to define the directory or file to be used on the remote server to complete the selected action for the Secure FTP Task (SSIS FTPS). The label will change to show what is needed (e.g.Directory location on server, File to be deleted from server). The ellipsis button [...] can be clicked to see the directories and files on the server. If a directory is needed for the action, only directories will be shown. If a file is needed for the action, directories and files will be shown, etc.

  • Directory location on server, Directory on server to upload file, File to download from server, Directory to create on server, Directory to delete on server, File to delete from server, File to check on server - Depending on what action is selected, this option is used to define the directory or file to be used on the remote server to complete the selected action for the Secure FTP Task (SSIS FTPS). The label will change to show what is needed (e.g.Directory location on server, File to be deleted from server). The ellipsis button [...] can be clicked to see the directories and files on the server. If a directory is needed for the action, only directories will be shown. If a file is needed for the action, directories and files will be shown, etc.

Secure FTP Task- Step 6
  • File Filter - This option is used to define a filter when using the "Download directory from server" option in the SSIS FTPS/STFP task. The filter uses the * wildcard. For instance, if the task is only to download txt file, the file filter would be *.txt.

  • Select result variable - Only available when using the "Check if file exists on server" action in the Secure FTP Task (SSIS FTPS). To use this action, you must select a variable to contain the result of the file check. Once the SFTP Task completes, the selected variable will contain the result.
The remote connection manager or variable for the remote path of the SSIS FTPS / SFTP can be set in the task expression as well.

  • File Filter - This option is used to define a filter when using the "Download directory from server" option in the SSIS FTPS/STFP task. The filter uses the * wildcard. For instance, if the task is only to download txt file, the file filter would be *.txt.

  • Select result variable - Only available when using the "Check if file exists on server" action in the Secure FTP Task (SSIS FTPS). To use this action, you must select a variable to contain the result of the file check. Once the SFTP Task completes, the selected variable will contain the result.
The remote connection manager or variable for the remote path of the SSIS FTPS / SFTP can be set in the task expression as well.

View Our Suite of Pragmatic Works Products
Copyright 2013 by Pragmatic Works
YouTube link Facebook link Twitter link Linked In link Login