Active X script to delete a file

#1

How can I write a delete file if there is one within
ActiveX scrpt?

I got an error at createobject line.

Function Main()
dim fs
set fs = createobject("scripting.filesystemobject")
fs.deletefile "\\mypc\shared\newfile.xls"
set fs = nothing
Main = DTSTaskExecResult_Success
End Function

Any advice would be help
Thanks.
Lintadsl

#2

Could be permissions, could be the file system library is
not installed on the client where executing, etc. It all
depends on what the specific error message is.

-Sue

On Mon, 17 Nov 2003 07:17:16 -0800, "Lintadsl"
<anonymous (AT) discussions (DOT) microsoft.com> wrote:

Quote:

How can I write a delete file if there is one within
ActiveX scrpt?

I got an error at createobject line.

Function Main()
dim fs
set fs = createobject("scripting.filesystemobject")
fs.deletefile "\\mypc\shared\newfile.xls"
set fs = nothing
Main = DTSTaskExecResult_Success
End Function

Any advice would be help
Thanks.
Lintadsl

#3

Hi I tried the function that you are using and it works fine as long as you
assign a drive letter to it, i.e. C:\mypc\shared\newfile.xls" I hope this
helps.

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

Quote:

How can I write a delete file if there is one within
ActiveX scrpt?

I got an error at createobject line.

Function Main()
dim fs
set fs = createobject("scripting.filesystemobject")
fs.deletefile "\\mypc\shared\newfile.xls"
set fs = nothing
Main = DTSTaskExecResult_Success
End Function

Any advice would be help
Thanks.
Lintadsl

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

Active X script to delete a file

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

Active X script to delete a file - 11-17-2003 , 09:17 AM

Re: Active X script to delete a file - 11-17-2003 , 09:41 PM

Re: Active X script to delete a file - 11-18-2003 , 04:24 AM