SSIS Merge Join not working as expected

Samuel THOMAS 96 Reputation points
2021-02-19T13:58:01.017+00:00

Hello,

I'm trying to reproduce in SSIS a simple inner join:

select *
from dbo.t_journee jou
inner join t_journee_element_planning jep on jep.jep_journee_fk = jou.jou_id

So I did in SSIS:
70095-image.png
70057-image.png

Both source have IsSorted set to True, and the joined columns have SortKeyPosition = 1

For the 1st test, I add the where on both of the source to restrict the perimeter:
(the SQL statement returns 19 lines for this test)
70083-image.png
This is the behaviour I was expecting, glad of this success, I decided to remove the WHERE from the left source...

But no more matching...
70064-image.png

Did I missed something?
I'm using VS 2015.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,482 questions
0 comments No comments
{count} votes

3 additional answers

Sort by: Most helpful
  1. Monalv-MSFT 5,896 Reputation points
    2021-02-22T09:35:03.57+00:00

    Hi @Samuel THOMAS ,

    I decided to remove the WHERE from the left source...
    But no more matching...

    Could you please share the example data in the left source and the right source?

    It seems that the left source does not have matching data with the right source.

    Please refer to Merge Join Transformation and Using the Merge Join Transformation in SSIS packages.

    Best regards,
    Mona

    ----------

    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

  2. Samuel THOMAS 96 Reputation points
    2021-02-23T08:11:27.907+00:00

    Thank you for yout time @Monalv-MSFT

    In the 2nd example, without the WHERE there should be at least the 19 rows present in the 1st eample (with the WHERE), no ?
    You want me to share 256.447 lines for the left source?

    0 comments No comments

  3. David Thorzen 0 Reputation points
    2023-01-16T15:02:59.3366667+00:00

    An addition that might help someone.

    I my case the problem was also white spaces in the key columns. After sorting and using Derived column TRIM() it finally worked.

    0 comments No comments