Home Forums Data Warehousing Integration Services How do I do an inner join where the join conditions are not equal in SSIS? RE: How do I do an inner join where the join conditions are not equal in SSIS?

  • August 25, 2013 at 11:38 pm

    #1644789

    sarah.cook (8/23/2013)

    Thanks very much for your reply. Very helpful.

    Looks like there's no real elegant way to do this (besides going through teh trouble to write a custom script) although I think I'll try the Merge Join - Conditional split.

    It's really too bad SSIS doesn't support this in a regular Merge Join component...

    In playing around, I have been just saving the values to a Temp table, and then doing my own update in the Control flow where I can then write in the sql code for the join, but this just breaks up all the processing and is really a work around.

    Thanks!!

    Sarah

    That may be so, but doing joins using the SQL Server engine is much faster than doing them in SSIS. So it may feel like a workaround, but perhaps if you instead consider it as a performance optimisation things won't seem so bad 🙂

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.