SFTP Task for SSIS

Start by creating WinSCP script file to transfer your files.

Below you can see basic script example for downloading file from SFTP server. For details see guide to automation or detailed documentation of scripting functionality.

option batch on
option confirm off
open yoursession -hostkey="ssh-rsa 1024 xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx"
get /remotepath/data.dat c:\localpath\
exit

In the script you need at least to:

• Replace yoursession argument to open command with specification of SFTP connection in form sftp://username@password:hostname or use name of stored session.
• Replace hostkey fingerprint after hostkey switch of open open command with actual fingerprint of your SFTP/SSH server hostkey;2
• Replace paths after get command with actual paths to remote file to download from and local directory to download to.

Save the script into file accessible from SSIS.

In SSIS, add new Execute Process task to control flow of your package. In the Execute Process Task Editor:

• Put path to WinSCP console interface tool (by default C:\Program Files\WinSCP\WinSCP.com) into Executable;
• In Arguments specify “/script=<pathtoyourscript>”.

• FAQ about SFTP task hanging when run from SSIS;
• Scripting documentation;
• Command-line parameters;
• Guide to scripting;
• FAQs about scripting;
• Troubleshooting.

• SFTP with SSIS Packages.