Another thought might be to implement an SSIS framework. I built mine from the instructions in SSIS: Problem Design Solution , or you can buy BI Express from Pragmatic...
It's hard to say without being there, but I would think that the kinds of validation queries you will need will be ok even with that volume of data. ...
I would disagree with the answer above and say it's one of the most important things to do. You should ALWAYS use surrogate keys in dimensions. Even if...