Post reply

Updating Global Variable via Scheduled Job

  • July 28, 2006 at 10:43 am

    #69226

    Hello,

    I have ActiveX script in  DTS that updates the value of a global variable:

    DTSGlobalVariables("MessageSentDate").value = Date

    This works fine when I execute the DTS manually but not when it is executed via a scheduled job.  Has anyone run into this problem before?

  • July 28, 2006 at 10:55 am

    #652170

    Are you expecting to open the DTS package after the job runs and see that the value of the Global Variable has been updated?  That's not going to happen. 

    The value of the Global variable will be updated within the context of the execution of the package though.

  • July 28, 2006 at 11:28 am

    #652176

    Yep, that is what I was hoping would happen.  Should I just use a table to store the value if I want it to persist?

  • July 31, 2006 at 5:33 am

    #652311

    i would think a table logging would be the best approach as the Global Variable within the DTS Package is unique to the instance of the package

    you could also have it email you

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

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