Post reply

CreateObject("WScript.Shell") Error in DTS

  • January 28, 2004 at 7:57 am

    #59115

    Hi,

    I am using SQL 2000. I created a Active X Script in DTS package , which uses the following code to create WScript Shell Object

    CreateObject("WScript.Shell")

    When I run the script from DTS package it works fine. But when I schedule the job it fails reporting Permisson denied on line xx ..that is on CreateObject("WScript.Shell") statement.

    I am running the DTS script on my local machine and job also scheduled to run on my loacl machine. Can anyone tell me how to resolve this issue.

     

    Thanks

  • January 28, 2004 at 11:40 am

    #492040

    I assume that you are a local administrator on your machine.  Thus when you run the dts package you have permission to do almost anything on your machine.

    When you run the dts package from a job, it is may use a different user, who may not have permission to load WScript.Shell.

    Because my SQL Server is running in the System account (may not be a good thing), the package runs.

    Hopefully, someone else can give you adequate information about the necessary permissions.

    Russel Loski, MCSD

    Russel Loski, MCSE Business Intelligence, Data Platform

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

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