You work as a database administrator at You are in the process of creating a SQL Server 2008 Integration Services (SSIS) data flow. The SSIS data flow obtains data from two databases that are hosted on two separate SQL Server 2008 database servers. Each source is based on a SELECT statement that includes an ORDER BY clause. However, you receive the following error message 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 need to ensure that the data from every query is contained in every row in the data flow. You thus need to determine a way to accomplish this. What should you do?

1)You should add a Lookup Transformation for each data flow.

2)You should add a Lookup Data Conversion for each data flow.

3)You should refresh the sorting properties in each source component.

4)You should add a Data Viewer object to the Data Flow.

  • : 359
  • : 13
    Previous Next

    You should refresh the sorting properties in each source component.

    Suggest other answer
    Login to Discuss/suggest the answer...

  • Exam: 70-448 MS SQL Server 2008, Business Intelligence

    Recommended Learning for you

    Subscribe here for free mock test on IAS PCS SSC and other competitive exam. Signup here to get SSC CGL Solution and main exam study material