I want to use a (Parent) package to call on several other (Child) packages. I
need to return from these Child packages specific Global Variable values in
order to determine what additional Child packages I need to call on.

In addition to this I need to pass some Parent Global Variable values to
some of these Child Packages too.

Now it would seem that this is the purpose of the "Inner/Outer Package
Global Variables". But I cannot get these to work.

What do I need to do to accomplish this? I would like to avoid any
ActiveScript objects. I realize you can call these packages thru code and
pass their parameters, but I want to know how to do it in the DTS Designer.

Thanks,

Inorder to use Global Variable you have to use
ActiveScript, otherwise you can not get the value. The
inner one is the Global Variable in your Child packages,
the Outer one the one from parent, so you can atrieve or
modify the parent Global Variable in the ActiveScript at
run time. you can't set parent Global Variable without
ActiveScript, you can only set Global Variable of package
itself w/o ActiveScript, which is not very useful. so by
all mean you got to use ActiveScript.

Or store the child output in an external location, such as a table, and
then query them back in the parent.


In message <179b01c50d6d$16986690$a501280a (AT) phx (DOT) gbl>, Justin Lee
<jlee (AT) discussions (DOT) microsoft.com> writes
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Hey thanks guys for your input.

You have helped me to answer the question. I have written DTS before that
took advantage of the Inner and Outer parameters within SQL Task objects. So
you would think that someone missed the boat with the Inner and Outer Package
Global Variables. I would think they should work in the same way.

Now let's hope that SQL 2005 gets it right.