Comparing two files

• Tyson Miller

  SSC Veteran

  Points: 204

  More actions

  November 13, 2007 at 7:56 am

  #183790

  SSIS Newbie.....

  I have two flat files that I created in IS that have account numbers. File 1 has a complete list of account numbers. I want to find the account numbers listed in this file that are not in file 2. Not sure what to use to do this.

  Thanks for your guidance.

• Daniel Meresa

  Grasshopper

  Points: 16

  More actions

  November 13, 2007 at 8:06 am

  #750701

  I think if you use the Lookup transformation it will help you. The Lookup transformation performs lookups by joining data in input columns with columns in a reference dataset.

• Tyson Miller

  SSC Veteran

  Points: 204

  More actions

  November 13, 2007 at 8:36 am

  #750719

  Thanks Daniel,

  So I would Redirect Row as Failed Component? (the un-matched rows)

• Daniel Meresa

  Grasshopper

  Points: 16

  More actions

  November 13, 2007 at 8:57 am

  #750735

  Yes, this examples help you a lot. http://blogs.conchango.com/jamiethomson/archive/2006/09/12/SSIS_3A00_-Checking-if-a-row-exists-and-if-it-does_2C00_-has-it-changed.aspx