Home Forums Data Warehousing Integration Services compare two datasets using ssis RE: compare two datasets using ssis

  • November 18, 2014 at 9:34 am

    #1759330

    scuby.me (11/18/2014)

    Hi,

    I have two tables in SQL server database. i want to compare both tables and differentiate like if the rows match then go to matched output otherwise to no match output.

    please suggest which transformation is best for this. i am using 2005 version.

    Thanks

    I think you are referring to the Lookup transformation.