It seems that there's a major problem with the FTP process in SQL Server. I understand that you can run the FTP with vbScript and the http://ftp.exe process that's native on the server.

I have some code that FTPs files from a web app to a server, and it uses Wscript to do it. I'll clean it up and see if I can't get it running in SQL Server. If I can, then I'd be happy to post the code.