Post reply

unable to delete files using FSO inside Stored Proc

  • September 27, 2007 at 9:49 pm

    #178165

    hi folks,

    here's a simple code that shows what I'd like to achieve:

    declare @fso int,@fldr int

    EXEC sp_OACreate 'scripting.filesystemobject', @fso OUTPUT

    EXEC sp_OAMethod @fso, 'DeleteFile("C:\temp\logout.gif")', @fldr OUTPUT

    Basically, I'm looking at deleting files using FSO inside SP but to no avail. Any thoughts ?:

    Cheers,

  • September 27, 2007 at 11:22 pm

    #737016

    fixed it, silly me..:D

  • October 1, 2007 at 9:24 pm

    #737985

    What was the problem (for others)? Security?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply