SSIS - Add a REPLACENULL() function to the expression language - by johnwelch

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 636057 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 1/13/2011 9:32:43 PM
Access Restriction Public


A REPLACENULL expression that works like the T-SQL ISNLL would be useful

Currently, if you are using ISNULL to determine whether to use the current value or replace it with another value (about 80% of cases for me) it results in an excessively long expression.
For example:
(DT_DBTIMESTAMP) (ISNULL(MyColumn) ? “1900-01-01” : MyColumn) –Now imagine this repeated about five times in a more complex expression.
(DT_DBTIMESTAMP) (REPLACENULL(MyColumn, “1900-01-01”)
Sign in to post a comment.
Posted by Microsoft on 5/24/2011 at 11:32 AM
Thank you for this feature idea. It has been added to the product, and should appear in the next release.

Matt Masson
Posted by GSpeareIronside on 5/20/2011 at 12:59 PM
This is about half of the derived columns I create in would be very helpful. Honestly I could even see a "replace null" data flow component being worthwhile.