SQL批量导入/插入多个表

I have a sitution where I need to import records from a flat file into several tables, making sure to keep tab on the resulting Primary keys for each row insert, for insertion into the next table. I have a sitution where I need to import record