I have been doing healthcare EDI processing for almost a decade now and I can tell you there is no "simple modifications" for an 837 file!! The 005010X222A1 Consolidated Guide that controls the document layout and usage is about 600 pages long!! :blink: Many segment/element identifiers can be found in different places throughout a transaction so you always have to track exactly where you are in the hierarchy. You can build your own parser that will keep track of where you are so you can navigate to the CORRECT address and CORRECT location to insert the REF with your invoice#. Beware the looping nature of the document.

I can say with complete confidence that SSIS is NOT the tool to use for what you wish to do. Best would be to already have a third-party product that can consume/process the 837 for you and use that. Failing that, you probably have to make your own parser using simple text file processing and the language of your choice. The parsing part isn't difficult really - it is all the looping and situational stuff that will drive you crazy. Oh, and TEST EVERY PERMUTATION!!

Best of luck with it! Feel free to drop me a PM if you need some professional assistance.