i have 1 excel file which has like id, name,address0, address1, address3
now i need to make package that take data from this flat file and in my database i have 3 table.
i need to place name,id in 1 table and address table should have all the address.
what componenet do i need, how can place some column to 1 table and another 2 another table.
Morever , i have name fileld like girg jow ,m
first ,last and middle name in1 column,how can i break that in ssis package.
plz help me