title: SSIS Merge Join not matching all rows on inner join
body: <p>I have two tables in Azure SQL Server which, when I query directly using <a href="https://i.stack.imgur.com/xpH3z.png" rel="nofollow noreferrer">SQL Query</a> on the 'GroupID', gives me the expected output of 5,698 rows.</p>
  <p>However, when I use <strong>Merge Join</strong> in SSIS
  <img src="https://i.stack.imgur.com/hRXgc.png" alt="Dataflow" /> only 4,832 rows are merged using the <strong>inner join</strong>.</p>
  <p>I've checked the metadata types (both are DT_I4 and Sorted, Position 1):</p>
  <blockquote>
  <p>&quot;Name&quot;    &quot;Data Type&quot; &quot;Precision&quot; &quot;Scale&quot; &quot;Length&quot;    &quot;Code Page&quot; &quot;Sort Key
  Position&quot; &quot;Comparison Flags&quot;  &quot;Source Component&quot;</p>
  <p>&quot;GroupID&quot; &quot;DT_I4&quot; &quot;0&quot; &quot;0&quot; &quot;0&quot; &quot;0&quot; &quot;1&quot; &quot;&quot;  &quot;INDEX&quot;</p>
  <p>&quot;Name&quot;    &quot;Data Type&quot; &quot;Precision&quot; &quot;Scale&quot; &quot;Length&quot;    &quot;Code Page&quot; &quot;Sort Key
  Position&quot; &quot;Comparison Flags&quot;  &quot;Source Component&quot;</p>
  <p>&quot;GroupID&quot; &quot;DT_I4&quot; &quot;0&quot; &quot;0&quot; &quot;0&quot; &quot;0&quot; &quot;1&quot; &quot;&quot;  &quot;ASSETS by ..........&quot;</p>
  </blockquote>
  <p>as many posts talk about data type inconsistency or trying to join on strings. I have checked that the source data results in a full inner join but I just can't see what could be causing the SSIS inner join to not work as expected.</p>
  <p>Any thoughts?</p>
  <p>Thanks</p>