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.
Pivot
C.
Multicast
D.
Lookup