Home Dashboard Directory Help
Search

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


Status: 

Closed
 as Fixed Help for as Fixed


5
0
Sign in
to vote
Type: Suggestion
ID: 636057
Opened: 1/13/2011 9:32:43 PM
Access Restriction: Public
0
Workaround(s)
view

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”)
Details
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
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.
Sign in to post a workaround.