You were right. The datasets were referred incorrectly.

In the merge join transformation, when I do an inner join I only get 1 record back. However, when I do a t-sql query I get all 3 records back.