Apologies if I'm asking something stupid here, but its the first time I've tried automating an sftp connection....
I have a site setup within the WinSCP gui which works well. When I connect it asks me for my Passphrase for the rsa key, which when I enter it then connects and all is well.
I've used the script generator option (with all options selected) to have it give me the connection details I need. However, when I run the script manually from the command line it then produces the same prompt for password as per the below;
Authenticating with public key "rsa-key-20161216".
Passphrase for key 'rsa-key-20161216':
Of course, if I manually add the key on the command line it will then connect. However, I'm hoping to automate the connection completely so I can script certain uploads/downloads as a scheduled task from Windows.
Could someone point me in the right direction?
Thanks in advance