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

create variable Expand / Collapse
Author
Message
Posted Thursday, February 28, 2013 1:15 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, February 27, 2014 10:41 AM
Points: 361, Visits: 1,781
Hi I am trying to create a user defined variable using the parent UD variable.
I am able to create but the scope is not like parent variable.

How to create a UD variable with parent Variable scope?
Post #1425268
Posted Thursday, February 28, 2013 10:25 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 7:44 PM
Points: 7,107, Visits: 12,661
Is this what you mean?

How to: Use Values of Parent Variables in Child Packages


__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1425346
Posted Thursday, February 28, 2013 10:48 PM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: 2 days ago @ 6:50 AM
Points: 617, Visits: 1,278
You will not find a scope like parent variable. You should create a variable as normal and scope it either to package or task level.

In youre package configuration you should specify this variable is populated from parent package variable.

So while execute this package, it will first try to configure it from the parent package, if not found , it will proceed with values available in child package itself.


-- Roshan Joe
*******************************************
Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help
Custom cleanup script for backups
Post #1425353
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse