SQL DTS is very simple, and you use VBSCript as your coding language. All you have to do to create a function to move a file or delete a file, or create a directory, is to write it. So you are only limited to your own imagination, well, almost. using an OOP language will give you many more options. But still, with VBScript you can do many, many things. All of the things that you are talking, and more. And everything is in the DTS Pacakge, so there is no need in having to keep up with a bunch of little files stuck every where, for everyone to that has access to see, and even worse, modify or delete. Thinking that no one is using them. Even better, when you move the DTS package, the code goes with it.

Check out www.SQLDTS.com, there are plenty of examples. You cna modify them and you have something different for a different task.

I used DTS for many years before SSIS. I created and performed all kinds of tasks and things using DTS. I never used an old fashioned command file. Download the VBScript reference from microsoft site, so that you have all the syntax, functions, methods, etc.... that VBScript has

Andrew SQLDBA