hi,
By following the kb
http://support.microsoft.com/default...b;en-us;321525
If I don't set any globalVariable , then LoadFromSqlSever and execute
method is fine.
AfterI add some scripts to set a gloablevariable value , I get errorcode
= - 2147220482 on the setp the variable first used.
Dim objGlobal1 As DTS.GlobalVariable2
For Each objGlobal1 In pkg.GlobalVariables
If objGlobal1.Name = "gsYM" Then
objGlobal1.Value = "'200502'"
End If
...........
Next

Any help is appreciated.

It maybe this issue-

"In order to change the value of a DTS Global Variable of type String from
VB.Net code, the variable must be programmatically removed from the
collection and added back with its new value."

DTS Global Variables and Visual Basic .Net
(http://www.sqldts.com/default.aspx?265)



"steffi" <steffibev (AT) hotmail (DOT) com> wrote