RonKyle (3/5/2010)
never use the build-in slowly changing dimensions wizard
Why would you never use it? I'm not a big fan of most wizards, but I find this one very effective.
I have found this component helpful in the past as well, there is a Kimbal Method SCD component on codeplex that I would seriously look at, it is at:
http://kimballscd.codeplex.com/
I have not actually used it myself.
CEWII