loading related tables from a .xls
Posted on 2011-02-17
How would you load related tables from one excel spreadsheet..
Basically this from one .xls
Needs to go into two tables obviously linked
Trying to use two data flows and a lookup I can’t figure out how to load the cities only once coming from a spreadsheet.. If I could do that, I could just use a lookup to load the marketed in the phone table..