Re: Is possible to FTP Upload with DTS instead of downloading a te

Tech-Archive recommends: Fix windows errors by optimizing your registry

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:

> 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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>
> > 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?
> >
> >
>
.

Relevant Pages

  • Re: DTS connection speed
    ... > Could you try transferring a similar amount of data over the same link ... Copy a file or FTP for example? ... All using the EXACT same source server and destination server. ...
    (microsoft.public.sqlserver.dts)
  • Re: FTP publishing denied by default rule
    ... What is the network relationship between the source & destination hosts? ... I'm trying to publish my internal FTP server to an external URL through ISA ... Destination IP: ...
    (microsoft.public.isa.publishing)
  • Re: Configure PF for desktop 4.1
    ... That setup is for server, ... Peter N. M. Hansteen, member of the first RFC 1149 implementation teamhttp://bsdly.blogspot.com/http://www.datadok.no/http://www.nuug.no/ ... download any packages from ftp. ...
    (comp.unix.bsd.openbsd.misc)
  • RE: Unusual FTP request.
    ... How would you determine the destination of the new ... Subject: Unusual FTP request. ... return code due to various problems on the remote (server) side. ... What the programmer would like would be for the production job to simply ...
    (bit.listserv.ibm-main)
  • Re: frontpage save results component
    ... I looked at the destination for File->Publish ... error regarding the server returning a response FrontPage could not parse. ... Do NOT use FTP, or a location with ftp in it. ...
    (microsoft.public.frontpage.extensions.windowsnt)