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.
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"
m=msgbox(DTSGlobalVariables("gv_"&DTSGlobalVariables("gv_CurrentProcess"
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.