Pass inner global variable from the parent pkg

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Data Transformation Services (DTS) » Pass inner global variable from the parent...

Pass inner global variable from the parent pkg

Rate Topic

Display Mode

Topic Options

Author

Message

ankur.jain2

Posted Friday, June 25, 2010 6:05 AM

Forum 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

PaVeRa22

Posted Monday, June 28, 2010 11:29 AM

Valued Member

Group: General Forum Members
Last Login: Tuesday, November 02, 2010 8:28 PM
Points: 73, Visits: 180

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 »

Permissions