This is rather a PowerShell question.

Anyway this works:

Actually documented here:
https://winscp.net/eng/docs/commandline#syntax

I've executed the script in PowerShell external it worked and it not worked inside SQL Server (PowerShell) it's a problem of certificate because the first one used it from cache.

Any idea how to add the certificate on SQL Server?

For information I can send file using PowerShell but not from the SQL Server Job Agent (that use PowerShell).

I replaced the spaces with a variable $s=" "

Any idea?

Hi,

I'm trying to upload a file to a remote server.

For information I'm using Microsoft SQL Server (job task) that use PowerShell.

So when I concatenate the parameters PowerShell do not ignore the whitespace and it cut it, Ex:

It give an error:

(Exception) **Host key does not match configured key

Because the hostkey passed do not match with the key that I sent (from the log).

It cut everything after the whitespace, I tested with a lot of combinations and nothing..

ex: ` | &('..')

For information all that I found is escaping the whitespace in the file path not in the parameters (theoretically it's the same) ex:
PowerTip: Run a PowerShell Script with Space in the Path - Scripting Blog [archived]
This is the documentation page: https://winscp.net/eng/docs/scripting

Any help will be so appreciated
Thanks