Post a reply

Before posting, please read how to report bug or request support effectively.

Bug reports without an attached log file are usually useless.

Options
Add an Attachment

If you do not want to add an Attachment to your Post, please leave the Fields blank.

(maximum 10 MB; please compress large files; only common media, archive, text and programming file formats are allowed)

Options

Topic review

martin

Re: Catching Error for missing file on FTP

Please read FAQ.
vivid

Catching Error for missing file on FTP

Hi
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 !