question

Gangadhar.marisetti avatar image
Gangadhar.marisetti asked

we have a target source table containing 3 columns: col1,col2 and col3 there is only 1 row in the table as follows

col1 col2 col3 a b c There is target table containg only 1 col.design a mapping so that the target table contains 3 rows as follows: col1 a b c
ssis
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton avatar image
ThomasRushton answered
select col1 union all select col2 as col1 union all select col3 as col1 from ; assuming the datatypes are compatible.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

KenJ avatar image
KenJ answered
You could take a look at UNPIVOT - either in SQL for the source query or as an SSIS transformation.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.