You can automate FTP push/pull. Check this out.

http://www.faqts.com/knowledge_base/view.phtml/aid/24489/fid/868

You can use xp_cmdShell stored procedure to invoke FTP command from your T-SQL.


>Hi,
> I have this DTS package that generates MDB file. After generation I want to copy it to ftp site. To do this I tried to use 'File Transfer Protocol Task'by writing a vb script in its workflow properties. In option tab I selected 'Use active x script' and then pressed properties button that opened the script editor. There I wrote the script. When I run that step, it says succeeded but in practice nothing happens.
>Is it the correct way of writing scripts in DTS package?
>How can I do step by step on the script (like debugging) as I didnot use vb script much.
>Is there any other way of copying files to ftp site?
>Thanks
>Bharat