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.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

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

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