passing DTS global variables into VB Script?

#1

I have some Global Variables i've defined within a DTS package that I want to
pass into an ActiveX (VB Script) task within the same package. Anybody know
how to do this?

Thanks,
Tom

#2

You can just reference those global variables in the script itself using
syntax like this

DTSGlobalVariables("My Variable Name").Value

"Tom P" <TomP (AT) discussions (DOT) microsoft.com> wrote

Quote:

I have some Global Variables i've defined within a DTS package that I want to
pass into an ActiveX (VB Script) task within the same package. Anybody know
how to do this?

Thanks,
Tom

#3

Thanks for the quick response Allan. It worked fine that way.

"Allan Mitchell" wrote:

Quote:

You can just reference those global variables in the script itself using
syntax like this

DTSGlobalVariables("My Variable Name").Value

"Tom P" <TomP (AT) discussions (DOT) microsoft.com> wrote in message
news:TomP (AT) discussions (DOT) microsoft.com:

I have some Global Variables i've defined within a DTS package that I want to
pass into an ActiveX (VB Script) task within the same package. Anybody know
how to do this?

Thanks,
Tom

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

passing DTS global variables into VB Script?

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

passing DTS global variables into VB Script? - 05-17-2005 , 03:31 PM

Re: passing DTS global variables into VB Script? - 05-17-2005 , 03:47 PM

Re: passing DTS global variables into VB Script? - 05-17-2005 , 04:06 PM