CODEWITHSUNDEEP
sql-serverssisetlssis-2014
Beginner
Beginner

Reputation: 91

SSIS 2014 - column mirroring

I have a table like below:

Col1 | col2 | col3 |col4 | col5

and now after reading this table i want to split it into two parts:

part 1 will have : col1 | col2 | col3 | col4

part 2 will have : col1 | col2 | col3 | col5

I want all rows from the source table to be present in both parts. Its just i have to split first 3 columns in both sides.

Could you please help me with this?

Upvotes: 0

Views: 29

Answers (1)

Ferdipux
Ferdipux

Reputation: 5256

You should use Multicast transformation. It duplicates rows among two or more outputs. Then you can drop unnecessary columns and direct data to your destinations.
A good tutorial on Multicast transformation.

Upvotes: 1

Related Questions