SQL Server Performance

Global Variables in Nested Packages

Discussion in 'SQL Server DTS-Related Questions' started by nilayinc, Aug 8, 2003.

  1. nilayinc New Member

    I 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.
  2. nilayinc New Member

    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 ?

Share This Page