Hello all
I have a flat file that that has a parent row (Customer data) in rows 1,3,5,7... etc and the CustomerDetail data in rows 2,4,6,...
I need to send Customer data to one table and the Details to another table.
How do i go about doing this in SSIS
Thanks