import data files from FTP site

#1

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.

#2

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

Quote:

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.

#3

Where do I find the Execute Process task?

"Allan Mitchell" wrote:

Quote:

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.

#4

Hello Rockitman,

In the toolbox

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

Quote:

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.

#5

Hi Allan, where is the toolbox?

"Allan Mitchell" wrote:

Quote:

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.

#6

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

Quote:

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.

#7

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:

Quote:

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.

#8

Hello Rockitman,

You do have it.

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

Allan

Quote:

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.

#9

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

"Allan Mitchell" wrote:

Quote:

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.

#10

Hello Rockitman,

Did you find the task I spoke of?

If you did then as I said earlier you will need to use something like FTP.exe.
Have a look here

How to manipulate the Execute Process task.
(http://www.sqldts.com/default.aspx?251)

Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Quote:

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.