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.