Do you have examples of SSIS expressions that you want to share? Consider adding them to this article, or just link to examples you've already published.
In Integration Services, expressions can be used to define conditions for CASE statements, create and update values in data columns, assign values to variables, update or populate properties at run time, define constraints in precedence constraints, and provide
the expressions used by the For Loop container. Expressions can be used in the Conditional Split transformation, Derived Column transformation, the For Loop container, variables, and properties of package.
With the expression results of DT_STR or DT_WSTR data type, the results are limited to 4000 characters till SQL Server 2008 R2.
This limit has been removed in SQL Server 2012.
For more information about expressions in packages, see these Books Online articles.
For additional examples of expressions, see:
Explains how to use FINDSTRING,SUBSTRING,and RIGHT within the Derived Column Transformation editor to clean up concatenated strings from SharePoint lists when importing the strings to SQL 2008. sqlstuff.weebly.com/ssis.html
Thank you DMigliore for adding the link to this blog post. I've included it in the article above.
I've tried reformatting the table multiple times but it does not render correctly on the Chrome browser. I've reported the issue to Google. It looks fine in IE9.