What is the best way to process a csv file from a remote server?

Hi all,

I want to read and process a csv file from a remote server in KNIME.

I have tried many things to get a connection to a remote server either directly via csv reader (by read from custom and use the URL ssh://…) or via ssh connection node, but it doesn’t work.

With ssh connection node, I can successfully connect to the system and get the filename in the results of the following nodes:

But how do I configure the csv reader node to use this filenname afterwards?

I have found many old (?) forum entries, where solutions are described, but these are not working for me (due to missing nodes or non-working connections).