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

  • October 16, 2014 at 3:37 pm

    #1752991

    venkat113 (8/31/2014)

    Hi Alvin,

    I have one requirement for process 835 files and loaded into database, Can you share your experience.

    Thanks,

    It's doable in SSIS, but it's a lot of work and I would only try to process X12 data in a data flow if I didn't have any good options.

    As mentioned in the post above, using a ".NET" data source, you can do almost anything. What took the most time to figure out was how to pass a value from one line to another line. That might have been the key item that dictated using a .NET source.

    Doable? Yes.

    Recommended as best option? No.

    FYI, I never did complete the process. I was only trying to prove that it could be done.


    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]