• Dave23 (8/24/2010)


    When I went looking for tips on X12 processing last year, I wasn't able to find any resources out there. In my case, I was able to get the vendor to provide a delimited extract instead, but I'm still interested in the possibility of processing X12-837 and HL7 files via SSIS.

    Thanks Dave,

    I'm pretty sure I've figured out how to handle an 850 (Purchase Order) file completely with single pass through a DataFlow. All I need is the time to actually try it.

    The same methodology should work with an 837. The main difference between an 850 and an 837 is the number of times you have to refer to information provided in an earlier segment.

    It's been a few years since I last looked at HL7, and thank God I never had to use HL7. I'll have to look at that too.

    I'll update this thread after I've tested my idea.



    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]