Delete contents of directory

[PreacherUK]

Hi,

I want to clear a directory of text files before I start populating it with new ones.

Whats the quickest most elegant way of doing this from a DTS package/Activex script task?

 

[JayKusch]

EXEC master..xp_cmdshell 'DEL C:\MyDir\'

Thanks

J. Kusch

 

[PreacherUK]

And will this delete all the text files in the directory or the directory itself?

 

[JayKusch]

That would be for all files but another method would be ...

EXEC master..xp_cmdshell 'DEL C:\MyDir\*.* /q'

Thanks

J. Kusch