Thomas Pagel BI Blog

Microsoft BI Technology & more

<November 2008>
SuMoTuWeThFrSa
2627282930311
2345678
9101112131415
16171819202122
23242526272829
30123456


Navigation

SSIS Blogs

SSRS Blogs

SSAS Blogs

Other SQL Server Links

Subscriptions

Post Categories



Thursday, August 18, 2005 - Posts

SSIS: Finding out about Properties and Expressions

SSIS brings a very cool feature with it... Expressions help you very much to dynamically change the behaviour of your package. There are already some posts about them around (i.e. search for “expressions” on Kirk’s blog http://sqljunkies.com/WebLog/knight_reign) so I don't want to talk too much about the feature itself. What I'm just thinking about (and posted on the technical forum http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=74473) is a way to find out which property is affected by an expression... OK, you can just look in the list of expressions (the place where they are defined), but just imagine you get a package and you wonder about why it behaves differently from what you see on the first sight... A very simple example would be a SMPT task sending a different message than defined in it's properties. After a while you think "well, that could be an expression" and... yes, there is one defined. So why don't make thinks easier by marking properties affected by expressions i.e. with a different colour or font. That would help a lot...

I'll pass that to Microsoft, too... Perhaps someone will take care of that...

 

Thomas

posted Thursday, August 18, 2005 9:24 AM by tpagel with 0 Comments




Powered by Dot Net Junkies, by Telligent Systems