SQL Server 2000

Help! Surely this has happened to others before me. A new customer wants to send updates in a fixed-width txt file in which master and detail rows alternate.

How do you do this?

Do you
1) Painfully muck around with 100,000 rows in the .txt file first--split it into 2 files, one for master records and one for detail records and then process?
2) Is there a way to feed it into 2 tables where rows starting with x go to one table and rows starting with y go to another?

The plan was to use a fast and dirty DTS package to shove this stuff into a table but I'd like some advice on how to proceed.

Thanks for any suggestions!

You'll probably get a better answer in the MS SQL Forum, this Forum is for the Open Source RDBMS mySQL. Hope that helps.

Thanks! I'll post there!