Lookup task failed to match the records correctly

• shreeprakashr

  SSC Veteran

  Points: 298

  More actions

  May 15, 2008 at 7:36 am

  #154354

  I am using SSIS 2005 Lookup task to match two tables. Though i have matching records between two tables, Look task still rejects records. We have used the same paramter to make the "inner join" between the two tables where the number of records return is not matching with results of Lookup task. The issue seems to be in SSIS Lookup task. Please let me know if you have faced the situation already. Thanks in advance.

• Michael Earl-395764

  SSC Guru

  Points: 53873

  More actions

  May 15, 2008 at 8:04 am

  #815898

  SSIS is very data type sensitive.

  It is also CASE SENSITIVE, ACCENT SENSITIVE, and SENSITIVE TO TRAILING SPACES.

  In your T-SQL join, your collation settings on the columns are used, they are not in SSIS.