title: SSIS left merge join partial matches
body: <p>In SSIS, when I'm trying to do merge join for table 1 and table 2 on "CourseName", the result shows only part of the column is mapped. That is , even though the values in those two tables are in the same datatype and have same "Coursename" , they are considered as "not match" in Left Merge Join in SSIS. Could someone help me out? </p>
  
  <p>P.S. </p>
  
  <ol>
  <li>The data type for both columns are nvarchar(30) </li>
  <li>Lookup is also not working...</li>
  </ol>