Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Pass inner global variable from the parent pkg Expand / Collapse
Author
Message
Posted Friday, June 25, 2010 6:05 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, June 25, 2010 6:00 AM
Points: 1, Visits: 0
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
Post #942991
Posted Monday, June 28, 2010 11:29 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, November 11, 2013 8:10 PM
Points: 73, Visits: 183
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
Post #944129
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse