good point. applying the template after the fact is nothing but pain and heartache. bi express is easier if your pockets are deep enough.

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...

I've created a few simple recon reports over the years. I don't know of a tool to do this for you, but there could be on out there somewhere....