sql server programming: hello,

(SQL Server 2000, DTS)

I have a parent package that includes a number of child packages. Each
child package is an Execute Task package.

I declare the global variables (e.g. SOURCE, DESTINATION) of the
parent package in the package properties. Then, I set them using a
Dynamic Properties task.

Then, for each child package (Execute Task package task), I set SOURCE
& DESTINATION to be the Outer Package Global Variables.

Now for my question: how do I accces the values of the global variable
once inside the child package? In my child package, I have a Dynamic
Properties task from where I cannot access the global variables from
the parent package.

Please can someone advise me on how to solve passing the variables
between packages?

Thanks

Checkout www.sqldts.com. There are several articles dealing with passing
global variables and you should be able to devise an approach based on them.

--
Anith