I have a Date type of Global variable, I would like to set system date as
default value of globle variable.

Any help will be appreciated.

Sally,
The only way I can think of is to create an ActiveX Script and do the
follow:

DTSGlobalVariables("VariablesName") = Date()

Edmund

"Sally" wrote:

If I want overwrite the default value of DATE global varible from programming,
Is it doable? Or The global variable always keeps the default value if we
use ActiveX script?

"Ed" wrote:

Global variable always keep the last value that you assign to it, it doen't
matter it is changed by programming or ActiveX Script
Ed

"Sally" wrote:

Thanks for your reply.
This is my code to execute DTS from programming, after I assign new date to
Date global variable "db" and execute it. However, in the DTS package , there
is ActiveX script to set system date to the "db" again, so it will overwrite
what I assiged from programming.

package.GlobalVariables.Item("db").let_Value(new Date());
package.Execute();

"Ed" wrote:

Depending on what you're doing, you could use a Dynamic Properties task and
use a query to assign a value tot he global variable.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"Sally" <Sally (AT) discussions (DOT) microsoft.com> wrote

I have a Date type of Global variable, I would like to set system date as
default value of globle variable.

Any help will be appreciated.