Share via

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

bk 466 Reputation points
2020-12-08T19:02:54.2+00:00

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

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,702 questions
0 comments
Accepted answer
  1. bk 466 Reputation points
    2020-12-08T20:16:38.987+00:00

    Thanks i have a parameter wrongly spelt , issue resolved.

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Yitzhak Khabinsky 26,586 Reputation points
    2020-12-08T19:08:37.847+00:00

    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)

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.