create variable

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » create variable

create variable

Rate Topic

Display Mode

Topic Options

Author

Message

nihal9200_kwada

Posted Thursday, February 28, 2013 1:15 PM

Old Hand

Group: General Forum Members
Last Login: Thursday, May 16, 2013 2:30 PM
Points: 352, Visits: 1,692

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

opc.three

Posted Thursday, February 28, 2013 10:25 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 8:26 AM
Points: 6,737, Visits: 11,791

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

joeroshan

Posted Thursday, February 28, 2013 10:48 PM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 5:48 AM
Points: 573, Visits: 1,169

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 »

Permissions