SSIS 14 - Staging Area - Merge two sources is taking a lot of time

user_6894244 0
Viewed 683

I've two tables:

  • Table A: 631 476 rows
  • Table B: 12 90 rows

Eache Table have the Field ID that I want to use it as Key in Merge Object. In the following image is possible to see that the process blocks before the Merge Object. I already test with Merge Join object and results are the same... enter image description here

Which other possibilities I have in order to make this operation using SSIS 14?

Thanks!

etl staging ssis merge sql-server
2 Answers
Related