SQL Server Performance

Global variable not updating

Discussion in 'SQL Server DTS-Related Questions' started by dwilson, Aug 7, 2003.

  1. dwilson New Member

    Hi All

    In a package I have, the first thing I do is update my global variables. When i use one of them in a transform data task it works fine with the updated value. In a subsequent task when i use it, it has the value from the last run of the package. Can anyone explain this, and how to fix it? According to the help files the variable will retain the value from the previous run if the package is saved but I am updating it first thing so I don't unserstand why that is happening.

    Dale
  2. satya Moderator

  3. dwilson New Member

    Problem solved. In my workflow I had my Dynamic Properties Task before my ActiveX Script Task when it should have been the other way around. Hey, I'm new to this. Thanks anyway.

Share This Page