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.


5
0
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

Description

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.
 
New REPLACNULL:
(DT_DBTIMESTAMP) (REPLACENULL(MyColumn, “1900-01-01”)
 
Sign in to post a comment.
Posted by Matt [MSFT] 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
SSIS Team
Posted by GSpeareIronside on 5/20/2011 at 12:59 PM
This is about half of the derived columns I create in SSIS...it would be very helpful. Honestly I could even see a "replace null" data flow component being worthwhile.