CODEWITHSUNDEEP
ssis
Neo
Neo

Reputation: 16219

How to i merge two results in SSIS?

I have two excel source 1st is giving me date value and 2nd is giving 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.

Upvotes: 0

Views: 1238

Answers (3)

Noam Kremen
Noam Kremen

Reputation: 418

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

Upvotes: 0

AJC
AJC

Reputation: 1893

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

Upvotes: 1

HLGEM
HLGEM

Reputation: 96552

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.

Upvotes: 1

Related Questions