Post reply

compare two datasets using ssis

  • November 18, 2014 at 9:24 am

    #301305

    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

  • 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.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply