Hi All, I am attempting to use the download tool to upload to an SFTP per the instructions here https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Upload-to-SFTP-FTP/ta-p/20845 I have had luck with this workflow uploading to other ftp's, but this client provided me with a host that is equivalent to an IP address, which I suspect may be a point of error. I have confirmed that I am able to access the SFTP via WinSCP, so I know that my credentials are correct, and that the public IP address associated to our network has been whitelisted- which is why im particulary confident that the errors are related to my tool configuration. The two errors im getting are the following: * When the address is set to the straight IP address i.e. XX.XXX.XX.XXX* Error Transferring Data: Couldn't connect to server * This fails consistently after 22 seconds * When i prepend sftp:// or sftp:// to the ip address i.e. "Sftp://XX.XXX.XX.XXX" or "FTP://XX.XXX.XX.XXX"* Error transferring data: Error in the SSH layer * This fails after roughly two seconds I've also tried applying the throttle tool after the block until done tool, because I was wary that the FTP may have a default query limit applied, but I still continued to encounter the above errors. I've also requested that the owners of the SFTP supply us with a different host name, but im not sure if thats possible, and have yet to hear back. Has anyone else had experience using the download tool to upload to SFTP, specifically when the host name is listed as a straight IP address? Any other suggestions for correctly configuring my tools I would appreciate it!

Using the download tool to upload to SFTP Error - correct address config

Hi All,

I am attempting to use the download tool to upload to an SFTP per the instructions here

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Upload-to-SFTP-FTP/ta-p/20845

I have had luck with this workflow uploading to other ftp's, but this client provided me with a host that is equivalent to an IP address, which I suspect may be a point of error.

I have confirmed that I am able to access the SFTP via WinSCP, so I know that my credentials are correct, and that the public IP address associated to our network has been whitelisted- which is why im particulary confident that the errors are related to my tool configuration.

The two errors im getting are the following:

When the address is set to the straight IP address i.e. XX.XXX.XX.XXX
- Error Transferring Data: Couldn't connect to server
- This fails consistently after 22 seconds
When i prepend sftp:// or sftp:// to the ip address i.e. "Sftp://XX.XXX.XX.XXX" or "FTP://XX.XXX.XX.XXX"
- Error transferring data: Error in the SSH layer
- This fails after roughly two seconds

I've also tried applying the throttle tool after the block until done tool, because I was wary that the FTP may have a default query limit applied, but I still continued to encounter the above errors.

I've also requested that the owners of the SFTP supply us with a different host name, but im not sure if thats possible, and have yet to hear back.

Has anyone else had experience using the download tool to upload to SFTP, specifically when the host name is listed as a straight IP address? Any other suggestions for correctly configuring my tools I would appreciate it!

Custom Tools

Best Practices

Download

Accepted answers

MichalM

Could you try appending a colon and a port number to the IP? I'd try 22 and 2222.

XX.XXX.XX.XXX:22

All comments

MichalM

Could you try appending a colon and a port number to the IP? I'd try 22 and 2222.

XX.XXX.XX.XXX:22

mkav9893

The suggested solution

XX.XXX.XX.XXX:22/

was successful! thank you

mkav9893

Hi @MichalM ,

The workflow ran without errors, however I'm not actually seeing it post to the sftp. The DownloadData field after the download tool is showing the following error:

SSH-2.0-OpenSSH_7.6
Protocol mismatch.

Any chance you have encountered this error before?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703