I am trying to write a job in SQL Server 2000 to download certain files from FTP Server using WINscp.
The SQL procedure writes a script to a text file and this script is used as parameter for running WINscp.
I want to devise a feature where in a mail needs to be sent incase the files are not available on FTP server (before attempting the download to local machine) .
Is there any way WINscp can throw an error specific to file missing or any other work around to trap the missing file message using a script.
I tried using a log but it just returns a NULL. So is there any way I can check in the script that the file which WINscp tried to 'get' is missing ?
Any inputs would be highly appreciated as I am quite novice with regards to WINscp.
Thanks a ton !