active X Script Question

[swoodring]

I want to do a simple active X script within my DTS. I'm bringing in a text file to transform it. Once I'm done I want to delete the text file. I want to just issue the Kill command to delete the file. But I don't see the Kill command listed in the list of functions. I tried to use it anyways it parses but when it runs comes back with an error type mismatch "Kill". Is there another way of deleting the file in VB script.

Stacy

 

[foxdev]

As an alternative, you could add a SQL process in your DTS job that executes xp_cmdshell with the command to DEL the file. Robert Bradley

http://www.lowcostprints.com

http://www.foxdev.com