Thanks i have a parameter wrongly spelt , issue resolved.
Winscp doesnt work when run as execute process task from SSIS Package
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
1 additional answer
Sort by: Most helpful
-
Yitzhak Khabinsky 24,011 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)