Checking if a Global Variables already exists
Set the globalvariable to a default value such as 0 for an int or "default"
for a string. Then in your script write something like
If DTSGlobalVariables("gvsubDir1").Value = 0 Then
DoThisStep
DTSTaskExecResult_Failure
Else
DoOtherStep
DTSTaskExecResult_Success
End if
This is probably easier than if you were to see if the variable exists.
Jonathan Kind
Fulfillment Systems Engineer
http://www.enews.com
Quote:
> How do I check if a global variable already exists referencing
> its name in a package using VBScript?
> SQL Server 7
