Expression Adorners

Published Mar 25 2019 03:17 PM 103 Views
Not applicable
First published on MSDN on Aug 13, 2011

A quick post today about SQL Server Denali.

BIDS now uses a special icon marker (called an Adorner) to indicate package objects that have expressions set on them. In CTP3, these adorners appear on Connection Managers and Variables. As I mentioned in my session at TechEd, the functionality has been further enhanced since CTP3, and we now add adorners to tasks as well.

Connection Managers

Variables

For those of you who are interacting with SSIS programmatically, you’ll also be happy to find a new HasExpressions property on all SSIS objects that support expressions (Tasks, Containers, etc). This property makes it easy to identify which objects have properties (without having to scan each property, like you would in 2008).

%3CLINGO-SUB%20id%3D%22lingo-sub-387960%22%20slang%3D%22en-US%22%3EExpression%20Adorners%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-387960%22%20slang%3D%22en-US%22%3E%0A%20%26lt%3Bmeta%20http-equiv%3D%22Content-Type%22%20content%3D%22text%2Fhtml%3B%20charset%3DUTF-8%22%20%2F%26gt%3B%3CSTRONG%3E%20First%20published%20on%20MSDN%20on%20Aug%2013%2C%202011%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3E%3CP%3EA%20quick%20post%20today%20about%20SQL%20Server%20Denali.%3C%2FP%3E%0A%20%20%3CP%3EBIDS%20now%20uses%20a%20special%20icon%20marker%20(called%20an%20Adorner)%20to%20indicate%20package%20objects%20that%20have%20expressions%20set%20on%20them.%20In%20CTP3%2C%20these%20adorners%20appear%20on%20Connection%20Managers%20and%20Variables.%20As%20I%20mentioned%20in%20my%20%3CA%20href%3D%22http%3A%2F%2Fblogs.msdn.com%2Fb%2Fmattm%2Farchive%2F2011%2F05%2F23%2Fwhat-s-new-in-denali-for-ssis-teched-2011.aspx%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Esession%20at%20TechEd%2C%20%3C%2FA%3Ethe%20functionality%20has%20been%20further%20enhanced%20since%20CTP3%2C%20and%20we%20now%20add%20adorners%20to%20tasks%20as%20well.%3C%2FP%3E%0A%20%20%3CP%3E%3CSTRONG%3E%20Connection%20Managers%20%3C%2FSTRONG%3E%3C%2FP%3E%0A%20%20%3CP%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F99693iF55029FFA126845B%22%20%2F%3E%3C%2FP%3E%0A%20%20%3CP%3E%3CSTRONG%3E%20Variables%20%3C%2FSTRONG%3E%3C%2FP%3E%0A%20%20%3CP%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F99694iC11667AA45594E06%22%20%2F%3E%3C%2FP%3E%0A%20%20%3CP%3EFor%20those%20of%20you%20who%20are%20interacting%20with%20SSIS%20programmatically%2C%20you%E2%80%99ll%20also%20be%20happy%20to%20find%20a%20new%20HasExpressions%20property%20on%20all%20SSIS%20objects%20that%20support%20expressions%20(Tasks%2C%20Containers%2C%20etc).%20This%20property%20makes%20it%20easy%20to%20identify%20which%20objects%20have%20properties%20(without%20having%20to%20scan%20each%20property%2C%20like%20you%20would%20in%202008).%3C%2FP%3E%0A%20%0A%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-387960%22%20slang%3D%22en-US%22%3EFirst%20published%20on%20MSDN%20on%20Aug%2013%2C%202011%20A%20quick%20post%20today%20about%20SQL%20Server%20Denali.%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-387960%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E30daysofssis%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Version history
Last update:
‎Mar 25 2019 03:17 PM
Updated by: