This is the script I use to backup all my DB's this does fulls and dumps them locally to disk then spools them off to FTP.
This stored procedure is designed to take 4 parameters
@bksrv: This is the name or the IP address of the spooler or backup server to send to.
@user: Login name for the FTP server
@upass: Password for the FTP server
@path: Local path files will be written to first.
Thats it there is no return value. There are errors raised and logged in the script.
Is there a cleaner better way to do this? I bet there is. I haven't seen one though.