SSIS to SFTP using WINSCP

Advertisement

chaitanya.brindavan@gmail.com
Joined:
Posts:
1
Location:
Seattle

SSIS to SFTP using WINSCP

Hey,

I am trying to export some files on my local folder to an SFTP location using SSIS....I need the command line to accept the hostkey always. Can you please let me know what am i missing here?

/command "open sftp://myusername:mypassword@myportal -hostkey="ssh-rsa 2048 ...........................="" "put D:\xxx\xxx\*.CSV /xxx/xxxx/" "exit"

Reply with quote

Advertisement

martin
Site Admin
martin avatar
Joined:
Posts:
33,846
Location:
Prague, Czechia

Re: SSIS to SFTP using WINSCP

You seem to have quotes wrong.
It should be like:
/command "open sftp://myusername:mypassword@myportal -hostkey=""ssh-rsa 2048 ...........................=""" "put D:\xxx\xxx\*.CSV /xxx/xxxx/" "exit"
See https://winscp.net/eng/docs/commandline#syntax

The easiest is to have WinSCP GUI generate a script template for you:
https://winscp.net/eng/docs/ui_generateurl#script

Reply with quote

Advertisement

You can post new topics in this forum