This guide contains description of creating SFTP1) file transfer task for SSIS using WinSCP scripting. Preferred approach is to use WinSCP .NET assembly from SSIS script task .NET code.
WinSCP offers scripting interface that you can use to automate file transfers to/from SFTP server.
Before starting you should:
Start by creating WinSCP script file to transfer your files.
option batch abort option confirm off open mysession -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:
opencommand with specification of SFTP connection in form
sftp://username:password@hostnameor use name of site (stored session).
hostkeyswitch of open
opencommand with actual fingerprint of your SFTP/SSH server hostkey;2)
getcommand 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:
C:\Program Files\WinSCP\WinSCP.exe) into Executable;
Site design by Black Gate