Winscp doesnt work when run as execute process task from SSIS Package

Question

Winscp doesnt work when run as execute process task from SSIS Package

bk 451

Hi All
I have a winscp script which when i run from the winscp command line , copies the files from the sftp server to the local drive and deletes the files from the sftp server. When i run the winscp script as execute process task , i do not get any error message, just a command prompt window pops up for a brief second and disappears and none of the files get copied over. Please advice. As there is no error message i do not know where to start looking for.

Thanks

Answer 1

bk 451

Thanks i have a parameter wrongly spelt , issue resolved.

Answer 2

Yitzhak Khabinsky 24,011

The preferred approach is to use WinSCP in SSIS Script Task.

It is documented here: Using WinSCP .NET Assembly from SQL Server Integration Services (SSIS)

bk 451 Reputation points

2020-12-08T19:35:28.84+00:00

Thanks, but that link doesnt have any information regarding this.
Yitzhak Khabinsky 24,011 Reputation points

2020-12-08T19:38:38.15+00:00
That link points to a correct page.
It has the following sections:

Installing

Using from SSIS

Deploying WinSCP .NET Assembly

Example C# Script Task Code
bk 451 Reputation points

2020-12-08T19:59:04.873+00:00

Thanks it says to use script task. I am using winscp and i have to use execute process task for that, Cannot by pass the winscp script
bk 451 Reputation points

2020-12-08T20:16:24.61+00:00

Thanks i have a parameter wrongly spelt , issue resolved.
Thanks

Winscp doesnt work when run as execute process task from SSIS Package

1 additional answer

Activity