I have been trying to pass a global variable from the parent DTS package to
the child DTS package. I am using the Execute Package task to invoke the
child package. I have added the two global variables on the Inner Package
Global Variables tab and the Outer Package Global Variable tab. The child
package never receives the Global variables from the parent DTS package. Am
I missing something?

Thanks

OK

here is what I did

2 Packages Caller and Called

Caller executes the Called package.

GV in the Called package

I set the GV in the Called package in the Inner Package Global Variables
section of the ExecutePackage task of the Caller package.

Works for me.

Do you have in the child package "Explicit Global Variables" set in the
package properties?

What is being picked up in the child?


--
--

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


"Tim Kelley" <tim.kelley (AT) iddonline (DOT) com> wrote

Allan,
When I enter the GV in the Called package in the Inner Package Global
Variables tab, the value is automatically set to what the value is in the
called program (I have defined the GV in the package properties). When the
Called package runs, this is the value that is being picked up. I have the
GV defined in both packages with the Explicit Global Variables set to yes
(is this correct).

Thanks for your time.

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

You define the GV of the child package in the child package (If Explicit GV
is set then it is case sensitive)
In the calling package (Inner Package GV tab) you should see a drop down of
the variables in the child package.
You can then enter the value you want to pass to the child value as well.

I can send you an example if you wish.



--
--

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


"Tim Kelley" <tim.kelley (AT) iddonline (DOT) com> wrote

Allan,
An example would be great. In the calling package how do I set the GV
when I call the called package at runtime?

Thanks




"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Throw me a mail privately as I do not want to send an attachment to the
group.

Thanks

--
--

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


"Tim Kelley" <tim.kelley (AT) iddonline (DOT) com> wrote