"Mark Frank" <mark.a.frank@wellsfargo.com> wrote in message
news:098f01c36281$2205e220$a001280a@phx.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

>-----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@wellsfargo.com> wrote in
message
>news:098f01c36281$2205e220$a001280a@phx.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
>
>
>.