Hello, I am loooking for code that will demonstrate how to create/remove a
global variable(s) at run time through an ActiveX script in my DTS package.

Thanks!

Ric

Hello Ric,

You could use something like this

Function Main()

dim gv

set gv = DTSGlobalVariables.Parent.GlobalVariables.New("A")

gv.Value = "Hello"

DTSGlobalVariables.Parent.GlobalVariables.Add gv

MsgBox DTSGlobalVariables("A").Value

Main = DTSTaskExecResult_Success
End Function


Unless you save the package after doing this then the GV is only valid for
the running of the package



Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com