Upload to SFTP

[Jes]

I have a workflow that downloads various files from sFTP, performs data transformation and outputs the result to.xlsx worksheet iin a SharePoint folder.

I am following the steps found in this post to upload the output file onto a sFTP server and am running into 'Couldn't resolve host name' error: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Upload-to-SFTP-FTP/ta-p/20845?light...

 

Troubleshooting steps taken:

1. The sFTP location has the file name & file extension embedded. I tried taking out the '/' at the end of the string and it still does not work.

2. Blob input tool has been configured as below:

3. Download tool has been configured as the following. Given that I use the same credentials to download files in the beginning of the workflow, the error is not related to my connection settings.

Any suggestions?

[BrandonB]

You definitely don't need the "/" at the end of the file name so you can take that out. The error that you are receiving is saying that the location you are trying to write to doesn't exist. Are you writing to a valid folder within your SFTP that definitely exists? 

[Jes]

Yes I am - Copied the sFTP folder location from WinSCP and so it definitely exists.