I have 2 Windows 2003 standard edition servers:
-Webbserver
-SQL server (MS sql server 2000).

Now I need to take some rows from the database and make a text-file. It
works perfect, but the text-file is on the sql server. I want it to be on the
webb server so people can download it thru HTTP.

But the FTP in DTS can only download or?

Or have someone another solution?

Couple of options - if these are both servers on your network, change your
destination using a UNC path similar to:

\\servername\share\folder1\folder2\file

Make sure that the account running the task has access to the destination. You
may have to change the service accounts from LocalSystem to a domain account if
they aren't running that way already.


Second option is to check out www.sqldts.com for some ideas on getting a Custom
FTP package for DTS. This will allow you to upload files. Note that if the
names of the files will vary, this will be a little tricky to work with. If
they're fixed, your good to go.

Another option is to handle this in some external process that looks for the
file and uploads it as needed. You can use FTP & batch files, special FTP
programs, mirroring apps, etc. I think that's probably overkill but it is worth
mentioning.

-Pete


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

I choosed "Second option is to check out www.sqldts.com " it was very easy to
get it to work, the file name was the same!

A big Thanx Peter!




"Peter A. Schott" wrote: