I want to use SSIS to do a normalization process for me. I have a single source table that need to be broken out into multiple destination tables. A simple example would be a table with Employee Name, Company Name, Emp address, Comp Address. The addresses need to be placed in the address table which has an Identity column to give each record a unique primary key to work with. That key needs to be used when the employee record is created in the emploee table and linked back to the correct address and the same for company info.

Can some one provide a very simple example of the data flow tasks to do something like this?

TIA