You are creating a SQL Server 2008 Integration Services (SSIS) data flow which gets information from two sources for Company.com.
You are in the process of creating a SQL Server 2008 Integration Services (SSIS) data flow.
Every source database is belongs to a different server and based on a SELECT statement which utilizes an ORDER BY clause.
The data flow is listed below:
You get error message below when you connect the paths from the two sources
“Data Flow Task: The input is not sorted.
The ‘input “Merge Join Left Input” (80)’ must be sorted.”
You should make sure that data from every search is contained in every row in the data flow. In order to solve the problem, which is the correct answer?
A.
You should increase a Lookup transformation for some data flows.
B.
You should increase a Lookup transformation for every data flow.
C.
You should refresh the sorting properties in each source component.
D.
You should choose a default transformation.