all groups > sql server dts > november 2004 >
You're in the

sql server dts

group:

DTS/FTP question from newbie


DTS/FTP question from newbie Fr NO[at]SPAM nk
11/12/2004 4:59:01 AM
sql server dts:
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
Re: DTS/FTP question from newbie Sue Hoegemeier
11/12/2004 9:14:38 AM
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"
[quoted text, click to view]
Re: DTS/FTP question from newbie Fr NO[at]SPAM nk
11/15/2004 12:05:03 AM
Thanks Sue,

I'll give it a go.

Cheerio,

Fr@nk

Frank Hepkema
Infoprofs
The Netherlands

[quoted text, click to view]
AddThis Social Bookmark Button