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: