Microsoft
70-458 · Question #150
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…
The correct answer is C. Conditional Split. See the full explanation below for the reasoning.
Question
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?
Options
- ALookup
- BMulticast
- CConditional Split
- DPivot
How the community answered
(34 responses)- A12% (4)
- B9% (3)
- C76% (26)
- D3% (1)
Community Discussion
No community discussion yet for this question.