Post reply

Pass inner global variable from the parent pkg

  • June 25, 2010 at 6:05 am

    #72051

    Hi All,

    I have 2 pkgs. Parent and Child pkg. Child pkg uses a Global Variable which I have well defined. The problem is when I try to execute the child pkg from another pkg (in this case, Parent Pkg). I understand this would be done using Inner Global Variable, but is there a way that I can pass this inner global variable using ActiveX Script to make it dynamic?

    Please let me know if further explanation is needed.

    Any ingights to this are highly appreciated!!

    Thanks

    AJ

  • June 28, 2010 at 11:29 am

    #1185939

    Dear AJ,

    Remove global variables from Child package, child will use the parent variables if you refer inside if Child which are declared in Parent and assigned values either in parent /child.

    Same approach in DTS / SSIS

    Parent : declare one global variable

    add script task, assign some value to global variable

    add execute package, call child package

    Child : DON't declare any variable

    Create script task, print (msgbox) parent variable

    execute parent, you will see parent variable value in child.

    Do not select inner/outer variables for this above example...

    Regards

    RB

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply