I am creating a DTS Package. So far I have an OLE DB connection, two Execute SQL Tasks, and an ActiveX Script Task. The two SQL Tasks each have on global output parameter each. In my ActiveX Script Task, in order to test the output values generated off these SQL Tasks, I have a MsgBox telling me these output values, written in VBScript.

I have a workflow set up to run the ActiveX Script, on success run one SQL Task, on success run the next SQL Task.

The problem I am having is that my output values are not being refreshed. If I execute the SQL Tasks individually and then execute the ActiveX Script, then I get updated values. But when I subsequently execute the ActiveX Script, I continue to get the most previous value, rather than real time. Suggestions?

--
Message posted via http://www.sqlmonster.com