I am trying to work with the SFTP and SSH.NET Package in order to download files (.xls) from SFTP:
Works fine so far, but unfortunately after download, files are empty (0KB) and I do get an error when I try to open the .xls: “the file format and the file extension do not match each other”.
I can accept to open these files, but they are empty.
In the Options for SFTP Scope, I got the correct Host Name, correct Password, correct Port Number, correct User Name.
In the Get Files Activity I got the correct Remote Directory Path.
So my guess is, it has somethng to do with the download activity.
I tried different things on the Remote Full Path but nothing really works