none
How to insert a Biztalk failed Message into SQLServer Database RRS feed

  • Question

  • Hi there

    I need to take an X12 file that is a failed Message and convert it to XML so I can insert it into a SQLServer database, but I keep hitting a wall. Sometimes I can convert it to XML and sometimes not, mostly not! I have tried many many different things with various degrees of success.  So I am open to suggestion? I am using Biztalk 2009 and I can always route the failed Msg in X12 to a certain folder.

    Thanks

    Tuesday, November 9, 2010 7:27 PM

Answers

  • Subscribe to failed message in a Orchestration . Have the Orchestration with a receive message type as System.Xml.XmlDocument.

    Insert the message.OuterXml into the database


    Sathish - http://blog.tsathish.com
    Wednesday, November 10, 2010 5:06 AM