I want to update an data field everytime a SCD updates its values. Problem is im not quite sure how to do this, because if you put getdate() as last updated in the SCD task in SSIS, that in itself would be a change.
How can I accurately reflect when a update on a row has occurred?
Can one use a trigger for that? Which is the best way to deal with this.