Search

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

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)
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 (expand)
Product Language
English

Category

Integration Services (DTS)

Proposed Solution

Implement a REPLACENULL function.

Benefits

Faster Development
Improved User Interface
Other (please provides details below)

Other Benefits

Cleaner, more readable code
File Attachments
0 attachments
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.
© 2013 Microsoft Corporation. All rights reserved. Microsoft Connect Terms of Use | Trademarks | Privacy Statement