"James Johnson" wrote:

> I have a DTS procedure that calls this code via stored
> procedure. Then I import the file into sql server.
> Problem is that it is not overwriting the file in my
> c:\localdirectory. Is there an attribute I should set
> in my text file or is should I delete the file in the
> directory before ftp'in the other file. If so how do you
> delete a file using DTS?
>
> --- text file ----
> open www.mywebsite.com
> myusername
> mypassword
> CD html/Uploads
> binary
> lcd C:\localdirectory
> get mytextfile.txt
> bye