Distinguished Field Update

Home Page Forums BizTalk 2004 – BizTalk 2010 Distinguished Field Update

Viewing 1 reply thread
  • Author
    Posts
    • #15508

      Ok.. I created a promoted field. I have code to update it as follows…

      [code:1:facfe57dbe]strFileName = WorkInProgressFlatFile(FILE.ReceivedFileName);
      WorkInProgressFileImportSqlRequest.FileImport.File = strFileName;[/code:1:facfe57dbe]

      If the file contains only one record all works fine. When there is more than one record in the file (ie message) I get the following error.

      [code:1:facfe57dbe]The result set for the XPath expression ‘/*[local-name()=’RecordInsertRequest’ and namespace-uri()=’http://XYZ.BizTalk.Schemas’]/*[local-name()=’FileImport’ and namespace-uri()=’http://XYZ.BizTalk.Schemas’]/@*[local-name()=’File’ and namespace-uri()=”]’ contains more than a single node. [/code:1:facfe57dbe]

      How do I get it to update all promoted fields? Or just the one its on? I want to set the promoted field to the file name it came in on so I can store it in the database.

      Thanks.

    • #15507

      Dave,

      you can’t use distinguished fields with repeating elements. You could just pass the message out to a .NET component as an XmlDocument object and have it update anything you need to.

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