SQLTeam.com | Weblogs | Forums

Upload Files To SFTP

Hi,

How to upload Files To SFTP Server.

Did you search in this forum for SFTP?

https://winscp.net/eng/docs/guide_ssis

This is the code i wrote in myscript.txt files to upoad files to FTP Server
option batch on
option confirm off
open //username:pswd@hostname
cd mydir
option transfer binary
mput *.csv Z:\Source
close
exit

Exceute process task is failing
Under executable i have assigned path as C:\Program Files (x86)\WinSCP\WinSCP.exe
Under Arguments i have specified /script=C:\myscript.txt

https://winscp.net/eng/docs/guide_ssis
This one is to get files from SFTP Server not to upload files to SFTP Server

Here is a guide for using a script task: https://winscp.net/eng/docs/library_ssis

This is the preferred method when using WinSCP and I have implemented this method. It works quite well...