You are developing a SQL Server Integration Services (SSIS) package to implement an
incremental data load strategy.
The package reads data from a source system. Depending on the value in a source column,
the package redirects rows to one of five different data flow paths.
You need to add a data flow transformation to support the package redirection.
Which data flow transformation should you use?
A.
Conditional Split
B.
pjvot
C.
Multicast
D.
Lookup
Explanation:
A) Conditional Split