SSIS SSH Components

This package consists of two SSIS control flow tasks and one connection manager.

This is the connection manager. Pretty self explanatory.
connection_manager.png

This is the execute command task. The command text is executed one line at a time on the host defined by the selected connection manager.
execute_command_task.png

This is the SFTP task in receive mode. The source file is downloaded from the host defined by the SSH Connection Manager to the directory defined by the Destination Connection Manager.
ftp_receive.png

This is the SFTP task in send mode. The source file is uploaded to the host defined by the SSH Connection Manager from the directory defined by the Source Connection Manager. The uploaded file is placed in the Send Files Destination Directory on the host defined by the SSH Connection Manager.
ftp_send.png

Last edited Feb 28, 2011 at 5:37 PM by nkuebler, version 6