Merge Join Problem

Question

Hi,

I've a problem with multiple packages with a merge join (full outer join) with a conditional split resulting in new, update and delete paths.

I've a merge join which combines data from a staging table and a destination table. I'm using a merge join with a key (but other packages with mmultiple keys give the same problem.. An initial load is working properly but when i rerun the package it seems that the keys are NOT matched properly. What could be the problem?

Greetz,

Hennie

Answer 1

What is the datatype of the join column? If string, any casing or spacing issues?

---

Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

Answer 2

Hi Joost,

I've already solved this issue. Thanks for your time and answer.

Forgot to sort one of the input queries (duh) resulting in totally strange behaviour of the Merge join ;-)

Thnx,

Hennie