Post reply

Execute Process not finding the "del" command !

  • January 10, 2007 at 3:34 am

    #175448

    Hello  All,

    i have a DTS in which i need to delete some file from a netwrk shared folder.

    I can not use xp_cmdshell as it uses the Sql server Local system account. So to solve it i am using a "Execute Process Task" because this task impersoates the executing domain user.

    Any way i am getting the "system can not find the specified file" when i am trying to use the "del" command. This same commmand works for the same user on the cmd shell.

    Can you please help me out ?

     

    Thank you for the time,

    Waleed

  • January 10, 2007 at 3:39 am

    #682325

    one note:

    i am already using xp_cmdshell to delete some local files.

    Maybe this is an issue with del not being an EXE / batch file ? if so is there any quick alternative ?

  • January 10, 2007 at 11:13 am

    #682489

    Have you tried an Active X Script task using the FileSystem object?

     

    Does the domain user have delete permissions for the folder the file resides in?

  • January 13, 2007 at 4:41 pm

    #683101

    The domain user does have permission to delete the files. And no i didn't try using the ActiveX FileSystem Object. Do i have to provide the username and password while running it or does it automatically impersonating the executer user ?

    Thanks

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

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