SSIS SQL Integration Service/SQL script- move data from flat table into relational db

Hi,

I have a database with a flat table. I need either a SSIS job or a T-SQL script that will simply take the flat data and move it into a relational database that I have created. The data will need splitting into 4 tables. I have already created the database and tables and will give you a script or backup so you can create it locally. Then I will give you the flat table pre-populated with data.

At the end I want a script that can move the flat data into the relational db and then I can query the relational db and I should get back the same results as the original flat table presented.

This can be done via an SSIS package or a T-SQL script. Those are the deliverables.

Any questions please ask. You need to have some demonstrable exprience with SQL Server and should be available this week.

Regards