Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Has anyone else found that their gl

Status
Not open for further replies.

ChrisLuv

Programmer
Jul 18, 2003
3
GB
Has anyone else found that their global variables disappear.

Sometimes I set the value of a global variable in an activeX script and the program runs fine. However when I check in Package...Properties I find that they are not in the system.

I can even output the value of the variable into a msgbox but they still don't exist when I look after the package has finished executing.

Can anyone help me? I'm not using explicit global variables but I am using a custom task called Open File Dialog Task that I found on could this have anything to do with it?

Here's a sample piece of the activeX task I am using:

Function Main()
DTSGlobalVariables("gv_"&DTSGlobalVariables("gv_CurrentProcess")&"_1")=DTSGlobalVariables("gv_New_1").Value
m=msgbox(DTSGlobalVariables("gv_"&DTSGlobalVariables("gv_CurrentProcess")&"_1"))
Main = DTSTaskExecResult_Success
End Function

So if gv_CurrentProcess = "bronze" then gv_bronze_1 is given the value of gv_New_1. Where gv_New_1 is a file location obtained through the custome task mentioned above.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top