I tried using the following code to automate an ftp upload:
exec master.dbo.xp_cmdshell 'cd D:\inetpub\ & ftp -s:froogle.txt "www.mysite.com
" & [myFTPusername] & [myFTPpassword] '
I cannot get the DTS package to execute this ftp task- nothing fails (no errors), but when I check my ftp site, the file never gets there.
Your help is greatly appreciated,