You work as a database administrator at Abc.com. 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. PreviousNext
Suggest other answer Login to Discuss/suggest the answer...
You can help us to improve by giving your valuable suggestions at email@example.com
By using the service of this site, I agree that I will serve wholeheartedly
and will not indulge in any sort of activity that threats the integrity of the organisation I am working for / I work for.
I have a firm believe in the notion that knowledge should be open source and
helping the needy and deserving part of society will always be my motto.
Knowledge is the power, Dont miss any paper, Subscribe to us