How to merge two columns of a table with SSIS
Hello,
how to merge two columns of a table using SSIS.
eg. EMPLOYEE.FIRSTNAME and EMPLOYEE.SURNAME to EMPLOYEE.FULLNAME
Thanks
October 29th, 2010 10:05am
Set up a Derived Column Transform and set the Expression to:
[FIRSTNAME] + " " + [SURNAME]
Todd C - MSCTS SQL Server 2005 - Please mark posts as answered where appropriate.
Free Windows Admin Tool Kit Click here and download it now
October 29th, 2010 10:25am