Dynamic Global Variables

#1

Hi all,

I have two identical processes, one for Actuals data, the
other for Plan data. I'd like to paramater drive a DTS
package based on the value of a global variable to switch
between the two. What I am looking for is 1) A way
(probably through ActiveX) to read the current value of
the global variable. 2) How to then use the dynamic
configuration task to fire of all the events where =
process 1, else fire events for process 2. Thanks in
advance for the help.

Mark Frank

#2

Sounds like you want this

Multiple Paths in Workflow
http://www.sqldts.com/default.aspx?6,103,218,7,1

--

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

"Mark Frank" <mark.a.frank (AT) wellsfargo (DOT) com> wrote

Quote:

Hi all,

I have two identical processes, one for Actuals data, the
other for Plan data. I'd like to paramater drive a DTS
package based on the value of a global variable to switch
between the two. What I am looking for is 1) A way
(probably through ActiveX) to read the current value of
the global variable. 2) How to then use the dynamic
configuration task to fire of all the events where =
process 1, else fire events for process 2. Thanks in
advance for the help.

Mark Frank

#3

This worked great. Thanks for the link.

Mark

Quote:

-----Original Message-----
Sounds like you want this

Multiple Paths in Workflow
http://www.sqldts.com/default.aspx?6,103,218,7,1

--

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

"Mark Frank" <mark.a.frank (AT) wellsfargo (DOT) com> wrote in
message
news:098f01c36281$2205e220$a001280a (AT) phx (DOT) gbl...

Hi all,

I have two identical processes, one for Actuals data,
the
other for Plan data. I'd like to paramater drive a DTS
package based on the value of a global variable to
switch
between the two. What I am looking for is 1) A way
(probably through ActiveX) to read the current value of
the global variable. 2) How to then use the dynamic
configuration task to fire of all the events where =
process 1, else fire events for process 2. Thanks in
advance for the help.

Mark Frank

.

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

Dynamic Global Variables

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

Dynamic Global Variables - 08-14-2003 , 11:28 AM

Re: Dynamic Global Variables - 08-14-2003 , 03:43 PM

Re: Dynamic Global Variables - 08-15-2003 , 08:09 PM