Well I am new to this and would like to answer one of the questions asked.

Why do we Denormalize the tables?

Normalization is used in Relational Databases. Relational Databases main concept...

Sure.!! I haven't started to move the packages yet to SSIS as I do not know the procedure yet. I just used upgrade advisor to check what changes will it...