Hi,

Try these links ,

Hope they will help you to put/ get the files to/from FTP Sites

http://www.simple-talk.com/sql/t-sql-programming/pop-rivett-and-the-ftp-directory/

http://www.virtualobjectives.com.au/sqlserver/ftp_scripts.htm

http://haacked.com/archive/2006/04/21/sqlstoredproceduretoftpfilesfromsqlserver.aspx

http://beyondrelational.com/justlearned/posts/608/upload-all-files-from-source-folder-via-ftp-in-sql-server.aspx

Thanks