It's difficult to handle error by using xp_cmdshell. For example, xp_cmdshell wouldn't return any message if the ftp site went down.

If your're familiar with VB Script, I suggest you to...