Clever Geek Handbook

Concatenate name and name as name and then omitmit Firtname and LastName in SSIS

I have a problem like below:

From a database source, I have a table that has data related to Person. Of which 3 columns are Title, FirstName, LastName and I want to replace that as Name before sending it to the destination.

I tried using a derived column, but it gives me the name (i.e. concatenation of Title, FirstName, LastName) and separate columns.

Please suggest.

+3


source to share


2 answers


You can just ignore the source columns when matching to the destination, or you can right click on the destination (or any transformation after the output column) -> show advanced editor -> enter columns and then uncheck the columns you don't need anymore ...



+2


source


First of all, your solution is good, even if the individual columns still appear, there is no need to match them, to the destination, just ignore them.

Another method

When using OLEDB Source

select Source type

as SQL Command

and use the following command:



SELECT [Title] + ' ' + [FirstName] + ' ' + [LastName] AS Name, ...
FROM MyTable

When using Excel Source

select Source type

as SQL Command

and use the following command:

 SELECT [Title] + ' ' + [FirstName] + ' ' + [LastName] AS Name
 FROM   [Sheet1$]
+1


source






More articles:


All Articles