Thursday, February 28, 2013 12:04 PM
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?
- Changed Type SSISJoostMicrosoft Community Contributor, Moderator Thursday, February 28, 2013 12:37 PM More appropriate type
Thursday, February 28, 2013 12:40 PMModerator
Thursday, February 28, 2013 1:32 PM
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 ;-)
- Marked As Answer by Hennie7863 Thursday, February 28, 2013 1:32 PM