Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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: Sunday, March 13, 2016 8:47 AM
Points: 362, Visits: 1,821
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: Friday, June 24, 2016 4:38 PM
Points: 7,917, Visits: 14,266
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


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Wednesday, June 15, 2016 6:29 AM
Points: 762, Visits: 1,548
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
Post #1425353
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse