What the best way to handle an import from an EDI style file in everyones
experience? I've always viewed them as nothing but positional flat files with
different kinds of positional records. So if my file has 10 record types, I
define 10 connections to the file with different positional columns defined,
then import the whole file 10 times into 10 record tables. Then I delete the
rows from each record type table that doesn't have the correct row
identifier. WHile this works, it seems like there would be a better way.
Thanks in advance for any suggestions.