Re: import data files from FTP site

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

Thanks for the info. Unfortunately, I don't see anywhere how to connect to
a FTP location and download files.

"Allan Mitchell" wrote:

Hello Rockitman,


You do have it.

Building a Package in the DTS Designer
(http://www.sqldts.com/default.aspx?278)

Allan

I'm afraid I don't have a DTS Designer. Again, I'm running old SQL
7.0.

I'm familiar with the DTS Wizard and Enterprise Manager, but this
Designer, I don't see.

"Allan Mitchell" wrote:

Hello Rockitman,

You see on the left in the DTS Designer? It will be in the bottom
half of that. Connection to the top and tasks underneath

Allan

Hi Allan, where is the toolbox?

"Allan Mitchell" wrote:

Hello Rockitman,

In the toolbox

I think it may have been called something slightly different in 7
though

Where do I find the Execute Process task?

"Allan Mitchell" wrote:

Hello Rockitman,

There are a number of ways to do this and a lot of them have
nothing to do with DTS.

You can use the Execute Process task (or 7 equivalent) to call
FTP.exe if you like

Allan

Is it possible to setup an automated job to download files from
an FTP site?

I am running SQL 7.0 on a Windows 2000 server.

I'm not sure how to proceed if it is possible.




.

Relevant Pages

  • Re: import data files from FTP site
    ... But it doesn't state anything about an ftp connection. ... "Allan Mitchell" wrote: ... How to manipulate the Execute Process task. ... You see on the left in the DTS Designer? ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS Designer Error
    ... "Allan Mitchell" wrote: ... > This would normally indicate "stamped on" dlls. ... >> I am getting an error when I try to open DTS designer through Local ... >> clicking on 'OK' the second time it puts me in to the designer but there ...
    (microsoft.public.sqlserver.dts)
  • Re: import data files from FTP site
    ... How to manipulate the Execute Process task. ... connect to a FTP location and download files. ... "Allan Mitchell" wrote: ... You see on the left in the DTS Designer? ...
    (microsoft.public.sqlserver.dts)
  • Re: import data files from FTP site
    ... You see on the left in the DTS Designer? ... Connection to the top and tasks underneath ... "Allan Mitchell" wrote: ...
    (microsoft.public.sqlserver.dts)
  • Re: import data files from FTP site
    ... I'm familiar with the DTS Wizard and Enterprise Manager, ... "Allan Mitchell" wrote: ... You see on the left in the DTS Designer? ... You can use the Execute Process task to call ...
    (microsoft.public.sqlserver.dts)