How to check if records from two tables match in SSIS?

Lookup transformation In some cases we are not able to do comparison if the data we want to insert in a table already exist in the table or no using SQL queries or stored procedures. In that case SSIS offer really nice task, Lookup transformation, that is easy configurable and easy to use. Lets assume I have Person table and Employee … Continue reading How to check if records from two tables match in SSIS?