CODEWITHSUNDEEP
ssis
user1645826
user1645826

Reputation:

Merge Join Transformation - Matching Multiple Columns

I Have two OLE DB Data Sources. one has the columns

ID, Premium

and the other has

ID, Premium, Cost

They are both in the same data flow and both sorted.

I use them both as a source for a Merge Join Transformation. I have told it that both ID and Premium are the ones to match on.

I was hoping for the output of this merge join to be ONLY rows where both ID and Premium both match. Instead what i seem to be getting is rows which match EITHER Id or Premium.

It is set to be an Inner Join as i dont want to get columns with Nulls / non matches in hanging around.

Does anyone know how to achieve the desired output? Am I using the right Transformation tool to achieve this?

Upvotes: 0

Views: 3210

Answers (1)

Jeroen Bolle
Jeroen Bolle

Reputation: 1836

You are using the correct transformation. However, by default the merge join transformation treats NULL values as equal. You can turn this off by setting the TreatNullsAsEqual property of the transformation to false. This way, you should get the same result as a regular SQL query.

Upvotes: 1

Related Questions