An Introduction to the SSIS Expression Languagehttp://sqlblog.com/blogs/andy_leonard/archive/2009/01/30/an-introduction-to-the-ssis-expression-language.aspxThe SSIS Expression Language is one of the steeper slopes on the SSIS learning curve. Many database professionals have never been exposed to the syntax. In this series, I provide examples that demonstrate common uses for the SSIS Expression Language.enCommunityServer 2.1 SP2 (Build: 61129.1)re: An Introduction to the SSIS Expression Languagehttp://sqlblog.com/blogs/andy_leonard/archive/2009/01/30/an-introduction-to-the-ssis-expression-language.aspx#11593Fri, 30 Jan 2009 22:57:17 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:11593Tim Mitchell<p>Andy, I'm glad to see this topic covered. &nbsp;I catch a lot of questions on forums about the SSIS expression language, and it took me a great deal of time (mostly trial and error) to get beyond the basics. &nbsp;This interesting syntax is still an enigma to many people, so I expect that you'll have a good deal of interest in this series.</p>
<p>Tim</p>re: An Introduction to the SSIS Expression Languagehttp://sqlblog.com/blogs/andy_leonard/archive/2009/01/30/an-introduction-to-the-ssis-expression-language.aspx#11771Fri, 06 Feb 2009 20:45:14 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:11771Log Buffer<P>"SSIS isn’t the newest thing around, but as Andy Leonard writes, 'The SSIS Expression Language is one of the steeper slopes on the SSIS learning curve. Many database professionals have never been exposed to the syntax.' If you’re one of those struggling your way up the curve, Andy’s Introduction to the SSIS Expression Language is for you."</P>
<P>&lt;a href="<A href="http://www.pythian.com/blogs/1474/log-buffer-134-a-carnival-of-the-vanities-for-dbas%22%3ELog" target=_new rel=nofollow>Log'>http://www.pythian.com/blogs/1474/log-buffer-134-a-carnival-of-the-vanities-for-dbas"&gt;Log</A> Buffer #134&lt;/a&gt;</P>re: An Introduction to the SSIS Expression Languagehttp://sqlblog.com/blogs/andy_leonard/archive/2009/01/30/an-introduction-to-the-ssis-expression-language.aspx#13665Thu, 30 Apr 2009 05:43:54 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:13665Duane Douglas<p>This is a nice tutorial about SSIS expressions. &nbsp;I moderate the MSDN SSIS forum and I often come across questions about or problems than can be solved with SSIS expressions. &nbsp;Despite its power, expressions are one of the least understood and least used conventions in SSIS. &nbsp;I'm confident that your tutorial on this subject could enlighten many more SSIS developers for years to come.</p>re: An Introduction to the SSIS Expression Languagehttp://sqlblog.com/blogs/andy_leonard/archive/2009/01/30/an-introduction-to-the-ssis-expression-language.aspx#18681Mon, 09 Nov 2009 16:39:01 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:18681Kent Krug<p>Andy,</p>
<p>Thanks for sharing this with me.</p>
<p>The problem that I'm still having is that I can change the value of a User Variable with Package Scope and view the change it break mode.</p>
<p>However after I stop debugging the original value persist.</p>
<p>In DTS the value of the Global Variable would be set to value that it was changed to when the Package was run.</p>
<p>Regards,</p>
<p>Kent</p>re: An Introduction to the SSIS Expression Languagehttp://sqlblog.com/blogs/andy_leonard/archive/2009/01/30/an-introduction-to-the-ssis-expression-language.aspx#22576Tue, 23 Feb 2010 14:55:40 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:22576Marty Nickel<p>A backslash doesn't escape a double quote in SSIS 2008. &nbsp;That fact is much-complained around the web and it seems that custom import routines are the only solution. &nbsp;To me this seems like quite a shortcoming.</p>re: An Introduction to the SSIS Expression Languagehttp://sqlblog.com/blogs/andy_leonard/archive/2009/01/30/an-introduction-to-the-ssis-expression-language.aspx#22812Thu, 04 Mar 2010 10:10:52 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:22812Sid<p>How would you execute the SQL expression built in your package?</p>re: An Introduction to the SSIS Expression Languagehttp://sqlblog.com/blogs/andy_leonard/archive/2009/01/30/an-introduction-to-the-ssis-expression-language.aspx#28893Wed, 22 Sep 2010 00:55:13 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:28893Gary Melhaff<p>Have you ever had a task not executing even though your precedence constraint is correct? &nbsp;</p>
<p>I had this problem and thought it was because I was comparing string variables to eachother (thanks to attunity oledb doesn't support returning count into anything but string variable). The real cause? &nbsp;I was trying to share an email task between 2 different sequence containers. SSIS apparently has a wonderful feature that if you do this you don't get an error - it just stops running as if it didn't meet the expression condition. Ouch - be nice if this was more widely advertised. btw...am running 2008r2</p>re: An Introduction to the SSIS Expression Languagehttp://sqlblog.com/blogs/andy_leonard/archive/2009/01/30/an-introduction-to-the-ssis-expression-language.aspx#28894Wed, 22 Sep 2010 01:44:03 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:28894andyleonard<p>Hi Gary,</p>
<p> &nbsp; Are you sure the precedence constraints are configured properly?</p>
<p>Andy</p>
re: An Introduction to the SSIS Expression Languagehttp://sqlblog.com/blogs/andy_leonard/archive/2009/01/30/an-introduction-to-the-ssis-expression-language.aspx#45914Fri, 02 Nov 2012 14:35:39 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:45914Jason Yousef<p>Nice article Andy, not sure what you meant by "If you want to include double-quotes in an expression, the escape sequence is backslash + " - \"." however the double quote is presented by "\"" for clarification. </p>