You are developing a SQL Server 2008 Integration Services (SSIS) data flow that extracts
data from two sources. Each source database is located on a different server. Each source
is based on a SELECT statement that uses an ORDER BY clause. The data flow is as
shown in the following diagram.
When the paths from the two sources are connected to a Merge Join component, the
following error message is displayed:
“Data Flow Task: The input is not sorted. The ‘input “Merge Join Left Input” (80)’ must be
sorted.”
You need to ensure that data from each query is included in each row in the data flow. You
want to achieve this goal by using minimum amount of execution time.
What should you do?
A.
Add a Sort transformation for each data flow.
B.
Add an OLE DB Command transformation for each data flow.
C.
Update the sorting properties in each source component.
D.
Replace the Merge Join transformation with a Union All transformation.
Explanation: