Re: Changing Global Variable valuses from within VBScript

#1

In the Accelerator an SQL-table is used to store these variables .. is this
because of the number of variables ? When direct coding is possible ?

Perhaps its because of the complexity in the packages where the variables
can be used by several packages ..

<g> wrote

Quote:

Great thanks.
"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote in message
news:uBNi3CZFEHA.2944 (AT) TK2MSFTNGP12 (DOT) phx.gbl...
It is possible

Here is an example

Function Main()

dim origVal, newVal

origVal = DTSGlobalVariables("MyVariable").Value

msgbox origVal

'Change

DTSGlobalVariables("MyVariable").Value = "Now I have changed"

newVal = DTSGlobalVariables("MyVariable").Value

msgbox newVal

Main = DTSTaskExecResult_Success
End Function

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

g> wrote

Is it possible to chage global variable values using VBScript, if so
how?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Changing Global Variable valuses from within VBScript

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: Changing Global Variable valuses from within VBScript - 04-04-2004 , 07:49 AM