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.
Enjoy