Post reply

DTS failed when executed by scheduler

  • May 27, 2008 at 7:50 am

    #129198

    Hi Gurus,

    I have a DTS to upload daily db updates to a file and ftp it. It ran to success when run it manually/ or through scheduler on my local work station. I have turn it over to a test server and dba has scheduled the job with sa user credentials. Now when the scheduler runs the job i am getting the following error.

    DTSRun OnStart: DTSStep_DTSActiveScriptTask_4

    DTSRun OnError: DTSStep_DTSActiveScriptTask_4,

    Error = -2147220482 (800403FE)

    Error string: Error Code: 0

    Error Source= Microsoft VBScript runtime error

    Error Description: Object required: 'DTSGlobalVariables(...).Value'

    Error on Line 35

    Error source: Microsoft Data Transformation Services (DTS) Package

    Help file: sqldts.hlp

    Help context: 1100

    Error Detail Records:

    Error: -2147220482 (800403FE);

    Provider Error: 0 (0... Process Exit Code 6. The step failed.

    Global Variables Option Explicit check box is checked. When I run it manually in test server it is running to success.

    Is it because of the user credentials? Is there any permissions to be given related to global variables? Please help...

    Thanks in advance, Sat

  • May 27, 2008 at 2:22 pm

    #820821

    From your error message, it does not seem to be a security issue, at least at this moment. The error is VBScript error with losing definition of an object.

    Please check your code and see if any piece was missing, and check with DBA to see if the job type (TScript, XScript, ...) was correctly set.

    May it help.

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

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