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 |
|
mhijnen
Starting Member
3 Posts |
 Posted - 2007-04-10 : 06:53:46
|
| Hi all,I want to copy 2 columns from 1 database to another database.I managed to do this, using a Ole DB source and a Ole DB destination dataset.Now I want to merge 2 colums into 1:Source Database: Column A: first name, Column B: Lastname.Destination Database: Column 1: First and lastname customer.Thanks for your help!Kind regards, Marcel HijneneXDe Solutions B.V. |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2007-04-10 : 08:29:44
|
Use a derived column transformation with an expression along the lines of:[Column A] + " " + [Column B] If either column is nullable, you'll need to test for null values (using the ISNULL function with the conditional operator - ?)Mark |
 |
|
|
mhijnen
Starting Member
3 Posts |
Posted - 2007-04-12 : 04:36:17
|
| Thanks! MarkCould you please define how to manage this in SSIS?Kind regards, Marcel HijneneXDe Solutions B.V. |
|
|
|
mhijnen
Starting Member
3 Posts |
Posted - 2007-04-12 : 08:58:58
|
| Sorry, It worksKind regards, Marcel HijneneXDe Solutions B.V. |
|
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2007-04-12 : 10:11:36
|
| no problem.Mark |
|
|
|
|
|
|
Copy columns from source to destination