Derived Column Functionality error

Question

I have 2 new columns from Derived Column functionality and I have to merge them both into one Column and feed it to the destination Table.

Derived column 1:

ABC
BBC
CBC

Derived Column 2:

HPC
DRT
RTY

Derived Column 3 should be

ABC
BBC
CBC
HPC
DRT
RTY

how should we do that thing ie adding 2 columns into one column — user2917483, Oct 31 '13 at 19:53
where are you trying to add two column together ?? what are their data types ?? What have you tried so far ? — M.Ali, Oct 31 '13 at 19:57
I have 2 columns created using derived columns I want both the columns to be made into one column both the columns are string type — user2917483, Oct 31 '13 at 19:59
SELECT Column1 + ' ' + Column2 FROM TableName .Should work fine if they both are same datatypes — M.Ali, Oct 31 '13 at 20:01

M.Ali · Accepted Answer · 2013-10-31T20:41:29.053

0

USE UNION ALL Transformation AND Then Derived Column SSIS will and map the columns. Union ALL with Combine the two column and Derived Column will put the combined columns in One Derived Column.

enter image description here

something like this..

edited Oct 31 '13 at 20:41

answered Oct 31 '13 at 20:11

M.Ali

67,945
13
101
127

I asked this in SSIS. – user2917483 Oct 31 '13 at 20:14
Its not mentioned anywhere in your question that you are trying to do this in SSIS, a TIP for next time if you have a question, Provide as much as information possible about your questions, Show what you have tried so far and if possible some Sample Data that what you have in your tables and What you want to do the desired Result set :) And most importantly Use the right Tags with your Question :) – M.Ali Oct 31 '13 at 20:31
can you once explain the answer you provided ? – user2917483 Oct 31 '13 at 20:32
I believe you have Two Derived Columns on you Data flow You need to Add a UNION ALL Transformation task onto your dataflow Map the columns then add another Derived Column. – M.Ali Oct 31 '13 at 20:40

Derived Column Functionality error

1 Answers1