SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 SSIS and Import/Export (2012)
 $Project variables
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

gbritton
Flowing Fount of Yak Knowledge

1094 Posts

Posted - 12/05/2013 :  16:27:07  Show Profile  Reply with Quote
I'm following a course in SSIS from PluralSight. In one module, an Execute Package task references a variable in the parent task like this:

@[$Project::foo]

where "foo" is a Project variable (new with SQL Server 2012)

I'd like to know:

1. Is this usage documented somewhere?
2. are there other variable groups that can/must be accessed with the "$" format? e.g. can I refer to varialbes with names like @[$Package::Name] or @[$Parent::Name]?

I'm looking for some reference docs on this.

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 12/06/2013 :  05:19:06  Show Profile  Reply with Quote
http://blogs.msdn.com/b/mattm/archive/2011/07/16/configuring-projects-and-packages-using-parameters.aspx

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

gbritton
Flowing Fount of Yak Knowledge

1094 Posts

Posted - 12/06/2013 :  08:59:40  Show Profile  Reply with Quote
quote:
Originally posted by visakh16

http://blogs.msdn.com/b/mattm/archive/2011/07/16/configuring-projects-and-packages-using-parameters.aspx




this is great! Can't believe I spent a whole day looking for it
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 12/07/2013 :  08:22:49  Show Profile  Reply with Quote
cool


------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.2 seconds. Powered By: Snitz Forums 2000