I am attempting to create a SSIS package that will check and see if the record (ID) exists, if true then check for data changes from each field. If change found then add new record, do not Update existing record. If no changes found then conitinue, Then check if Record(ID) does not exists and insert all new records.
How do I modify the SSIS package to compare existing record for data changes? Which object do I use for the comparison?
Thanks,
Karen