How and where do I reset a global variable? I have a global Variable that
needs to be reset to 0 everytime the Package executes. Currently it does not
reset to 0.

Thanks in advance

Marinus

The variable will be reset at runtime to it's design time value. The only way to change it would be to change it at runtime then
resave the package.

You could of course have a task at the very start of the package that says

DTSGlobalVariables("Variable Name").Value = 0



--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com


"Marinus Willemstijn" <willemma (AT) telkom (DOT) co.za> wrote