Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2003
    Location
    Longmont, CO
    Posts
    258

    Unanswered: text file feed with alternating master and detail rows

    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!

  2. #2
    Join Date
    Apr 2003
    Location
    Edison, NJ / Oakland, NJ (Work)
    Posts
    32

    Wrong Topic

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

  3. #3
    Join Date
    Jun 2003
    Location
    Longmont, CO
    Posts
    258

    Sorry!

    Thanks! I'll post there!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •