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 20,721 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)
-
That link points to a correct page.
It has the following sections:
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
Thanks i have a parameter wrongly spelt , issue resolved.
Thanks
Sign in to comment