SSIS Derived column check nulls for concatenation


We can concatenate firstname and Lastname with checking null like this  to avoid null result: SELECT ISNULL(FName,”) + " " + ISNULL(LName,”)   AS FullName
But this will not work in SSIS’s derived column. Instead, use the following syntax to concatenat a FullName derived column:

(ISNULL(FirstName) ? "" : FirstName) + " " + (ISNULL(LastName) ? "" : LastName)

There is a link at technet.microsoft.com for a step by step guild for this: http://technet.microsoft.com/en-us/library/ms365300.aspx

Advertisements


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s