How to delete a file from remote server using DTS

#1

Hi

I need to delete a file from remote server in one of the tasks in DTS package. Any pointers on this would be of great help

Thanks
Ajit

#2

What is remote about the server? How can you connect to the server? That
really isn't much to go on so I'll make a few guesses-

Use a UNC path and DOS delete.
Use SQL to call xp_cmdshell 'DEL File'
Use ftp.exe and a script with delete in.

--
Darren Green
http://www.sqldts.com

"Ajit" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:

Hi.

I need to delete a file from remote server in one of the tasks in DTS
package. Any pointers on this would be of great help.

Thanks,
Ajit

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

How to delete a file from remote server using DTS

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

How to delete a file from remote server using DTS - 03-02-2004 , 04:51 AM

Re: How to delete a file from remote server using DTS - 03-02-2004 , 06:24 AM