SSIS Null Value Questions
Posted
by Saobi
on Stack Overflow
See other posts from Stack Overflow
or by Saobi
Published on 2009-07-09T19:30:24Z
Indexed on
2010/04/21
21:43 UTC
Read the original article
Hit count: 222
I have a table with 5 string columns, all can be NULLs. After I read the data from this table, I want to convert any null values into empty strings. The reason is that I need to compare these columns with columns in another table of the same schema (using conditional split), and null values would cause the comparison to evaluate to NULL.
Is there any functionality in SSIS that allows me to convert NULL's to empty strings, or just not having to deal with NULL's at all?
© Stack Overflow or respective owner
