How to i merge two results in SSIS?

I have two excel source 1st is giving me date value and 2nd is giving开发者_JAVA技巧 me price value from excel sheet.

Now i need to insert these two values into one table please tell me how can i do this?

I have used merge join but it is giving me error input must be sorted that i can't as it excel file.

Well personally, I would put each Excel file into it's own staging table. Then I would use a SQL query that joins the two tables as the source for my insert to the production tables.

After you get the input from each source, you have to sort it prior to merging it.

You can sort the input from an Excel source, from any source, because the sort is performed with the data on memory. Its an element in the Toolbar.

Check this: http://msdn.microsoft.com/en-us/library/ms137653.aspx

I'm pretty sure you can define a sort on an excel