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