we have our database in sql 2005 version Enterprise Edition .
Because of performance issue we have normalized database and now required data transfer from denormalized database to normalized database.all tables has been created.
Denormalized database have 429 tables, some of them have greater than 5 millions rows.
In this condition one table data may needs to be transferred in 3 different tables of normalized database.
which would be the best approach to do data transfer from one database to another
i.e script or ssis package..?