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
Thanks