Home Forums SQL Server 2005 SQL Server 2005 Integration Services Lookin for Reference for EDI Using SSIS and X12 Format Files RE: Lookin for Reference for EDI Using SSIS and X12 Format Files

  • August 25, 2010 at 6:06 pm

    #1212006

    CozyRoc (8/25/2010)

    Hi Alvind,

    As I understand you have found first-hand it is not easy to flatten or transform EDI data into tabular data flow format. There is a third-party commercial solution for SSIS called CozyRoc EDI Source, which has been available on the market for 2 years now. It has been already successfully used to process 210, 810, 812, 820, 822, 832, 834, 835, 850, 852, 855, D95B. I suspect 837 format can be handled as well. The link to the documentation I have sent you contains sample configuration and input file for 852 format. This could give you a pretty good understanding what is involved in the creation of specific configuration files.

    Thanks for the post.

    I am aware of your 3rd party solution. I'm trying to come up with a good way of doing this without using 3rd party tools.


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]