I have a problem in running a DTS. My DTS package has 5 different Steps which is at first step I have a ActiveXScript ruuning. What it does is it takes an excel file (testfile.xls) in the server, copies that file to another folder with Today's Date. Then Renames it to "test.xls" . Then in Step2 I have a connection that take that excel file "test.xls" and Imports it to database.
at the step 5 I have another ActiveXScript which I need to delete that file "test.xls" . When it gets to the step5: I get the permission Denied. I think the file is still open! (not sure)
But when I run it seperatly it runs successfully.
Could you give me solution for that.
Thanks

For me, I've always had problem with delete file privileges using Scripting.FileSystemObject (I imagine this is what you are using?). How I always got around this was I put the file in a new folder and deleted the whole folder. I'm not sure myself what this may be; it may be file or folder permissions.

Hope this helps,

Brian