Now I know I'm not the only one having this issue. Two issues actually.
1. When a column changes and is recognized in the History Preserving transform, the records Active flag is set to 0 (which is fine, that's what I want) but it's Effective_End_Date is somehow changed to the same value of its Effective_From_Date.
2. When the row from Issue 1 is updated, the new Inserted row (the new active row for that key) is inserted with an Effective_From_Date of the previous records row. WHAT? Why does it do this? Why doesn't it set the Effective_From_Date to the current system time?
I'm sure that both issues are related and fixing one will fix the other. Buy why is it doing this????