http://sqlblog.com/blogs/davide_mauri/archive/2012/03/21/replacenull-in-ssis-2012.aspxWhile preparing my slides e demos for the forthcoming SQL Server Conference 2012 in Italy , I’ve come across a nice addition to DTS Expression language which I never noticed before and that seems unknown also to the blogosphere: REPLACENULL. REPLACENULLenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlblog.com/blogs/davide_mauri/archive/2012/03/21/replacenull-in-ssis-2012.aspx#42440Wed, 21 Mar 2012 23:29:20 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:42440Tony<p>Cool. There seem to be lots of nice things in 2012 that aren't getting much attention - the other day I found in books online that 2012 now supports online index operations for LOB columns! I think thats huge, but I've not seen it mentioned anywhere.</p> http://sqlblog.com/blogs/davide_mauri/archive/2012/03/21/replacenull-in-ssis-2012.aspx#42446Thu, 22 Mar 2012 12:29:02 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:42446jamiet<p>Don't forget about TOKEN &amp; TOKENCOUNT too :)</p> <p><a rel="nofollow" target="_new" href="http://sqlblog.com/blogs/jamie_thomson/archive/2011/07/12/ssis-enhancements-in-denali-ctp3.aspx">http://sqlblog.com/blogs/jamie_thomson/archive/2011/07/12/ssis-enhancements-in-denali-ctp3.aspx</a></p> http://sqlblog.com/blogs/davide_mauri/archive/2012/03/21/replacenull-in-ssis-2012.aspx#42497Tue, 27 Mar 2012 01:14:24 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:42497Charles Kincaid<p>Nice. &nbsp;Available in SSIS only, is it. &nbsp;Pity. &nbsp;Would be very nice in T-SQL as well. &nbsp;REPLACENULL is a bit more obvious than COALESCE. &nbsp;At least to me it is.</p>