I'm trying to set up a DTS job to FTP from SQL2000 to Unix. I seem to only
be able to use UNIX as a source not a destination.

Is there another task I should be using to move a file from SQL to Unix?

Thanks.

Ron

The stock FTP task does not support uploads, it is not a UNIX prejudice, it
just supports downloads.

You can try this task-
SQLDTS File Transfer Protocol Task
(http://www.sqldts.com/default.aspx?302)

If it works then feel free to use it, if not try ftp.exe via the Exec
Process task. Either will work, but the FTP task has a UI, so may be easier.


--
Darren
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com

"Ron" <Ron (AT) discussions (DOT) microsoft.com> wrote