Explanation/Reference:
Explanation:
D: The Union All transformation combines multiple inputs into one output. For example, the outputs from five different Flat File sources can be inputs to the Union All transformation and combined into one output.
E: The Merge transformation combines two sorted datasets into a single dataset. The rows from each dataset are inserted into the output based on values in their key columns.
By including the Merge transformation in a data flow, you can perform the following tasks:
* Merge data from two data sources, such as tables and files.
Etc.
Incorrect:
The other commands cannot be used to combine data from two different sources.
References:
https://docs.microsoft.com/en-us/sql/integration-services/data-flow/transformations/merge-transformation?
view=sql-server-2017
https://docs.microsoft.com/en-us/sql/integration-services/data-flow/transformations/union-all- transformation?view=sql-server-2017