Mapping .msg to XML to SQL

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Mapping .msg to XML to SQL

Viewing 1 reply thread
  • Author
    Posts
    • March 17, 2013 at 11:40 PM #26016
      community-content

        I have configured POP3 in receive port and able to receive all emails and stored as .txt file.

        How do I map this file to a schema and store the content to an SQL table?

        Each line in the email body represents a field’s data in the table.

        Any help would be appreciated.

         

      • March 31, 2013 at 5:01 PM #26030
        community-content

          Write the body out to a file folder. and in other Receivelocation use a FlatFile Disassemble pipeline which will convert the body file to Xml format and then map it to SQL Schema and send it further to SQL SendPort. Or you can call the FlatFile Disassemble pipeline directly from the Orchestration which will return you the XML.

      • Author
        Posts
      Viewing 1 reply thread
      • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.