Topic "Catching Error for missing file on FTP"

Author Message
[View user's profile]

Joined: 2008-01-15
Posts: 1
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 !
[View user's profile]
Site Admin
Joined: 2002-12-10
Posts: 27083
Location: Prague, Czechia
Please read FAQ.
Martin Prikryl

You can post new topics in this forum


What is WinSCP?

It is award-winning SFTP client, SCP client, FTPS client and FTP client integrated into one software program for file transfer to FTP server or secure SFTP server. [More]

And it's free!


About donations

$9   $19   $49   $99

About donations


WinSCP Privacy Policy

WinSCP License