Uploading multiple files to SFTP

Question

Hi,

I am generating multiple .csv files in a workflow and I want to push each individual file to a SFTP server. How would I go about doing this?

I need to be able to convert each file output to a blob and then push it to the server. How can I loop through each row to do this?

Thanks!

daraghwalker · Answer

The folder is the same for all files. I am just appending the file name to the end of the SFTP string as normal.

The upload count is sporadic, sometimes 30, 35, 40, 41. I cannot tell the reason why. I have messed around with the timeout and maximum connections, and still no luck.

Very stuck on this one.

Thanks!

Matt_D · Answer

Hi @daraghwalker how long is it taking to get to this point? I'm thinking 1 of 2 things (but I'm not an expert). Either a timeout issue (default timeout in the Download Tool is 600 seconds) or the path you're trying to pass the files to does not exist on the sFTP side.

Is there anything different about the location you're trying to pass file 46 to or are they all the same?

Thanks,

Matt

daraghwalker · Answer

Thanks @Matt_D . I ended up getting it working in the end.

But now I'm getting the following error:  Download (120) Error transferring data: Error in the SSH layer

I have a total of 51 files, and only 40-45 get uploaded to the SFTP.