Re: Using Winscp to download file from SFTP in SSIS
Sorry, but "it is not working" is not working as a problem description.
See https://winscp.net/eng/docs/troubleshooting#scripting
Btw, WinSCP can download files with the current date in their file name on its own. No need to generate the name externally.
See https://winscp.net/eng/docs/scripting#timestamp
There's somewhat similar (although not exactly same) example here:
https://winscp.net/eng/docs/script_download_timestamped_filename
See https://winscp.net/eng/docs/troubleshooting#scripting
Btw, WinSCP can download files with the current date in their file name on its own. No need to generate the name externally.
See https://winscp.net/eng/docs/scripting#timestamp
There's somewhat similar (although not exactly same) example here:
https://winscp.net/eng/docs/script_download_timestamped_filename