i'm agree for the SCD wizard, but i thought u wanted something different.

i have a real pleasure to read all that post on this subject 🙂

I didn't use the codeplex one, and the merge option as well, and actually for me, dimension should not contains millions rows 🙂

but i accept the fact that sometime, we don't have choices.

:hehe: