Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2003
    Location
    Hyderabad
    Posts
    6

    Unanswered: urgent - scheduled job fails due to environment variables

    Hi

    Am trying to schedule a job which uses dynamic proerties task and environment variables. scheduled the job with owner as 'sa'. When try to run this job it is giving the following error:
    --------------------------------------------------------------------------------
    Executed as user: sai\SYSTEM. DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSDynamicPropertiesTask_1 DTSRun OnError: DTSStep_DTSDynamicPropertiesTask_1, Error = -2147220489 (800403F7) Error string: Environment variable 'abcUDL' not found. Error source: Dynamic Properties Task Help file: Help context: 0 Error Detail Records: Error: 0 (0); Provider Error: 0 (0) Error string: Environment variable 'abcUDL' not found. Error source: Dynamic Properties Task Help file: Help context: 0 DTSRun OnFinish: DTSStep_DTSDynamicPropertiesTask_1 DTSRun: Package execution complete. Process Exit Code 1. The step failed.
    ----------------------------------------------------------------------------------

    when the same package is executed from Enterprise Manager it is executing fine. Am working on standalone machine. Need help in this context.

    Thanks

  2. #2
    Join Date
    Jul 2003
    Posts
    5
    Maybe this is coincidencde, in your output is says :
    Executed as user: sai\SYSTEM.
    Shouldn't that be userid SA (and not SAI) ?

    HtH

  3. #3
    Join Date
    Feb 2003
    Location
    Hyderabad
    Posts
    6
    SAI is my computer name. I am using 'sa' as login.

  4. #4
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •