all groups > sql server dts > september 2005 >
You're in the

sql server dts

group:

Updating global variables


Re: Updating global variables Darren Green
9/6/2005 12:00:00 AM
sql server dts:
Unless you get an error I'd say the script is running fine. The most likely
cause is you are referencing two variables in different places. Variable
names are case sensitive. First thing to try is turn in the Explicit option
for global variables, see Package properties.

Variables are implicitly created if they do not exist already.

Another useful test is to log all you global variables, at run-time, to an
external location an view them afterwards.

Global variable diagnostic script
(http://www.sqldts.com/default.aspx?303)


--
Darren Green
http://www.sqldts.com
http://www.sqlis.com


[quoted text, click to view]

Updating global variables Silmar
9/6/2005 11:41:34 AM
Hi!

I created a DTS package which has an ActiveX Script Task as one of its
elements. Below is some part of it

strNumer = DTSGlobalVariables("NumerPliku").Value
DTSGlobalVariables("NumerPliku").Value = strNumer + 1

When I run this package withing DTS Designer global variable is updated. But
when I run it via schedule or by manully executing it from EM it does not
work :(
How to fix it?

Regards
Silmar

AddThis Social Bookmark Button