I don’t know that you need a Transfer Files node if you use the optional input port on the CSV Writer to accept an SSH connection directly. Something like this may work?
(Click the three dots in the bottom left corner of the CSV Writer to make the blue port show up.)