Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Royal
Starting Member
32 Posts |
 Posted - 2007-01-27 : 11:27:35
|
| I have 2 data flows tasks, salesperson and customer, where I want to concatenate name and Lastname into Name, using a Derived Column... [name] + " " + LastnameIn the first one, Destination Preview show NULL on every Name row. In the other the names are joined as "DanWinter". Why don't the concatenate according to expression? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-01-28 : 05:53:39
|
| isnull(name + ' ', '') + isnull(lastname, '')Peter LarssonHelsingborg, Sweden |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-01-28 : 11:52:18
|
"Why don't the concatenate according to expression?""NULL + anything" gives NULL  Kristen |
|
|
|
Royal
Starting Member
32 Posts |
Posted - 2007-01-29 : 13:09:51
|
| hmm...your expression is not accepted..This one works (ISNULL([name]) ? "" : [name]) + (ISNULL(familyname) ? "" : familyname)but the Destination Preview till shows NULL on every Name row in first flow and names joined as "DanWinter" in the other data flow task. |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-01-29 : 14:14:47
|
| Peso gave the t-sql syntax whereas you needed the ssis expression syntax which is what you have now (nice isn't it).It sounds like there's something wrong with the inputs to the tasks (if you're sure you're viewing the derived column).Have you tried running it? Could just be something wrong with the preview.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
[name] + " " + Lastname