SFTP transfer using Execute Process Task and WinSCP in SSIS

2
votes

I am having a User_file.txt file placed at WinSCP root folder USERDATA, which I am trying to download to the given location C:\User\Local\.

Executable- C:\Program Files (x86)\WinSCP\WinSCP.exe
Arguments - /log=c:\path\to\log\winscp.log /command "open ftp://username:[email protected]/" "get /USERDATA/User_file.txt C:\User\Local\" "exit"

I am facing below error:

No connection could be made the target machine actively refused it

Not sure what I am missing. I took reference from couple of related post on Stack Overflow.

1
ssissftpwinscp
Can you connect to that server anyhow? Like in WinSCP GUI? Or when running the command-line manually (outside of SSIS)? Why do you tag the question sftp, but use ftp:// in the script? - Martin Prikryl
Yes. I can access to it using GUI.. and I want to get the file using sftp - vikrant rana
@Martin Prikryl-- Could you please help me on below question. I am struggling to fix this. stackoverflow.com/questions/56685315/… - vikrant rana

1 Answers

1
votes

You want to use SFTP, but use FTP (ftp://) protocol in the session URL.

Use sftp:// instead:

... "open sftp://username:[email protected]/" ...

WinSCP GUI can generate a correct script/command-line template for you.