Catching Error for missing file on FTP

Advertisement

vivid
Joined:
Posts:
1

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 !

Reply with quote

Advertisement

Advertisement

You can post new topics in this forum