Saturday, February 25, 2012

Only 9999 Rows after MERGE JOIN in SQL Server BIDS

I've gote 2 Tables with about 50.000 rows and I left outer join them with MERGE JOIN.

The result are 9999 rows. Has anybody got the same problem. Maybe it's a bug!?

Daniel Krebs wrote:

I've gote 2 Tables with about 50.000 rows and I left outer join them with MERGE JOIN.

The result are 9999 rows. Has anybody got the same problem. Maybe it's a bug!?

Merge joining is one of the trickiest components to use in SSIS. First make sure the data is sorted when it gets into the merge join; then you have to tell to the data flow pipeline how the data is sorted by changing some properties in the source component. Alternatively, you could place a Sort transform before the merge join; but that is resource consuming, so it may be better to use the DB engine if you are using tables. Then make sure the join type is properly set (you have to know your data).

Lastly, check some threads on this forum that talk about problem with Merge join and review BOL topics

http://forums.microsoft.com/MSDN/Search/Search.aspx?words=merge+join&localechoice=9&SiteID=1&searchscope=forumscope&ForumID=80

|||You may want to do the join as SQL query in your source adapter.

No comments:

Post a Comment