March 3, 2011 at 10:05 am
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
March 3, 2011 at 10:46 am
Where are the EDI messages? Do you have them or are they at a VAN?
March 3, 2011 at 11:01 am
I have EDI messages in .MRP extension file.
March 3, 2011 at 11:26 am
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
March 3, 2011 at 8:52 pm
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