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: Wednesday, April 16, 2014 9:25 AM
Points: 7,070, Visits: 12,523
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

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy
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: Monday, April 07, 2014 12:42 AM
Points: 613, Visits: 1,252
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