Dear all,

please forgive me if I'm posting this in the wrong group, I'm very new to
SQL-server and DTS.

The question is:
Is it possible to delete files from a FTP-site after one has copied (using
the FTP task in DTS) them to the local machine. It probably is, but how does
one do this?

Thanks for any help!


Frank Hepkema
Infoprofs
The Netherlands

Frank,
You are posting to the correct newsgroup.
The FTP task in DTS is limited. To get more functionality
with FTP, you can use an Execute process task and execute
command line ftp and it's commands directly.
Often, it's easier to use an FTP script file to execute the
commands. You would just use a command like:
ftp -sC:\PathToYour\FTPFile

In the file, you would just enter the following:
open <ftp site>
<login>
<password>
delete <your file>
bye
The windows help file has details on the ftp commands.

-Sue

On Fri, 12 Nov 2004 04:59:01 -0800, "Fr@nk"
<Frnk (AT) discussions (DOT) microsoft.com> wrote:

Thanks Sue,

I'll give it a go.

Cheerio,

Fr@nk

Frank Hepkema
Infoprofs
The Netherlands

"Sue Hoegemeier" wrote: