Hi JoyKing

For SCD2 to work your destination table needs to have 3 extra columns - Effective Date (datetime), Expiry Date (datetime), and Current Record (bit). (You can use different names...