I need to create a text file from data in sql server, then ftp the file to a
UNIX server on the same network. Creating the text file is no problem, but
when it comes to the FTP I'm stuck. Does anyone know if it's even possible
to ftp to UNIX via DTS?

thanks,
Rebecca

Rebecca,

FTP is a universal protocol and works on UNIX too. See ftp commands topic in
Windows Help.

Ilya

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

Rebecca,

As Ilya stated, you should be able to access an FTP site to send data from
DTS.

Depending on what you're attempting, you can use the FTP Task to download,
but if you want to send files to an ftp site,you'll need to use other
means.. http://www.sqlteam.com/item.asp?ItemID=12408
This is only necessary if you're not using SSIS.

If you're using SSIS, then take a look at the FTP task which allows you to
download and upload to an FTP site.


"Ilya Margolin" <ilya_no_spam_ (AT) unapen (DOT) com> wrote

Hello Rodney,

Or you could of course use this.

SQLDTS File Transfer Protocol Task
(http://www.sqldts.com/default.aspx?302)

Allan