Forum » Scripting / Automation »

Post a reply

Options
Add an Attachment

If you do not want to add an Attachment to your Post, please leave the Fields blank.

(maximum 10 MB; please compress large files; only common media, archive, text and programming file formats are allowed)

Options

Topic review

martin

Re: When using -hostkey option in script mode, open command fails with "Too many parameters" error.

The correct syntax is: 
winscp.com /command "open sftp://username:password@ipaddress -hostkey=""ssh-rsa 1536 XX:XX:XX:XX:XX:XX:XX:XX:XX"""  "get xxx"  exit

Note the =

See https://winscp.net/eng/docs/scriptcommand_open#examples
Guest

When using -hostkey option in script mode, open command fails with "Too many parameters" error.

I cannot use the -hostkey option with the open command in a script.

When I try like this: 
winscp.com /command "open sftp://username/password@ipaddress -hostkey ""ssh-rsa 1536 XX:XX:XX:XX:XX:XX:XX:XX:XX""" "get xxx" exit

I get the following error:
Too many parameters for command 'open'

I get the same error when I tried rearranging and placing the -hostkey option first, like this. 
winscp.com /command "open -hostkey ""ssh-rsa 1536 XX:XX:XX:XX:XX:XX:XX:XX:XX"" sftp://username/password@ipaddress" "get xxx" exit

The exact same command like works without the -hostkey value, but only from my interactive session where I have the key stored. However, I need this to work from an automatically scheduled SSIS job, and it always fails to accept the key from the SFTP site since it runs from the SQLServerAGENT user.

Documentation

Support

Associations

Follow Us