SQL Server Performance Forum – Threads Archive
Global variable not updatingHi 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
May take help of this link http://www.sqldts.com/default.aspx?6,107,280,7,1 that would assist you. _________
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.