hello all. i have an employee table and i would like to know which records changed on a weekly basis. for example i would like to know when a person changes departments or locations (building,floor,room).
ideally i would compare the current table against the previous table and export the changes to a third table or an excel file. i have an employee ID which is my PK.
i have played around with the SCD transform in SSIS but it appears to be overkill and is difficult for a semi-newbie to conquer. i am not concerned with overwriting any records SCD 1 or creating any SCD 2 type records.
what would be the best way to go about this?