EDI x12 to Table

  • Hello,

    Iam using sql server 2008. I need to extract data from EDI(Electronic Data Interchange) X12 format commonly known as 4010 format, into a Table.

    Thanks in advance

  • Where are the EDI messages? Do you have them or are they at a VAN?

  • I have EDI messages in .MRP extension file.

  • I have not dealt with EDI in a few years, so I'll try to help with what I remember.

    What kind of mapping software do you use?

    If you set the maps up yourself, the easy solution would be to create another destination point (database) with a table that mirrors the transaction set you are trying to log, instead of just putting it into the system you are pushing the transaction set to.

    If this is not an option, try using SSIS to shred the EDI and load into a table that mirrors the transaction set. So if this is a 944(warehouse stock transfer) remember to account for the looping that happens in the edi document to build the BOL, because you may be shipping 5 pallets of spaghetti, 12 pallets of macaroni, etc.

    chris

  • Thanks a lot chris

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply