I'm trying to reproduce in SSIS a simple inner join:
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:
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)
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...
Did I missed something?
I'm using VS 2015.