Hi,
I'm just getting my feet wet with SSIS, and I'm having some trouble
with the Slowly Changing Dimension transformation. I'm processing
Type 2 SCDs, and in addition to creating a new current dimension
record/setting the old dimension record to expired, I would
additionally like to write out to a table the new surrogate key that
is now current along with the old surrogate key that has just been
"expired". I cannot figure out how to modify the transformation to do
this. Any help would be greatly appreciated.

Many thanks,
Heather