New to SSIS - Create pkg to validate data, does it exists in a table

[kfschaefer0727]

Looking for samples and how to create an SSIS pkg that will validate if record already exists, if not add as new record else, if exists then check to see if any part of the record has changed. If true than create new record, not to update existing record. Else add as new record. How do I do the comparison of the data for each record in the table(s) and handle it appropriately? Which is the best approach in SQL Server/Visual Studio tools.

Thanks,

Karen