SQL Server Performance Forum – Threads Archive
Global Variables in Nested PackagesI have multiple packages within a DTS package.
Each child package has global variables which are used by it’s contituent tasks. The parent (outer most) package receives values for these global variables from the caller programme. how can I pass the values to the child packages from the parent package ?
Alternatively how can I have only 1 set of global variables which can be used by all child packages ?
All child packages and the parent package use 1 set of global variables.
I came across something called Inner and Outer Package Variables which mite be the solution to this. But I don’t know their usage. Can someone throw some light on this ?