Hello, I have a problem when transforming (copying) data into a new table. Although the column names are different, I have some columns with the same label, i.e:

data1 DECIMAL(13,2) LABEL "Label 1",
data2 DECIMAL(13,2) LABEL "Label 1"

So, when I click on the "Transformations" tab, data1 is supposed to be copied into the new destination field, i.e., "newdata1" but data2 is not copied into "newdata2". Instead of that, also data1 is copied into "newdata2". This happens because SQL Server seems to be taking not the field name but the label name. I mean, because of both of the two source field have a label named "Label 1", SQL Server always takes the first one (data1) and with this field it fills in the two destination fields, loosing the content of data2 this way.

Is there a way to tell SQL Server not to map the source columns by label but by column name?

Thanks a lot.

PD: I know this information may be confused. If you have any questions or doubts, please, post it. I'll be glad to answer in order to get a solution.

PD: There's no way to change the label names because these tables are already working in a complex enterprise and any change in the structure of any table may be catastrophical.

take each step separately.
first transform your data1 data to NewData1, on success
transform your data2 data to newdata2 or create a new table destination table.