MS SQL Server DTS - SSIS

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

SSIS - Edi format

sqlboy2000

2006-03-27, 9:35 am

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.

Sponsored Links