While working SSIS in 2008 we have encountering some weird problems with Merge, Merge Join and Condition Spilt transformations, here are the details...
Condition Split and Merge Join and Condition Split:
Please check the below diagram(not really just tried) for the complete details.
Just FYI data is in sorted order
condition Split -> 420000
| 18 | 419982
Merge Join(left) -- src1(6000)
the merge join transformation is not returning the complete 18 rows to the next transformation that's why we are missing 8 rows.
But if we adds a sort transformation (getting warning as data is already sorted) before merge then complete 18 rows were passing to the condition split.
Also tried modifing the source query just to return 18 rows then also it was passing the 18 rows to next trasnformation except with full load.
We have two sorted data sources and first one has 40000 records and second source have 12000 records and after the Merge transformation we have Condition Split transfor
View Complete Post