Problems with BizTalk rules

I'm a bit of a newbie with BizTalk and have come across a problem that I hope
you can help me with or point me in the right direction.

At the moment, I have a set of rows in a database whose values I want to sum
up using the business rules composer and place the result into a XML file.
What is currently happening is that the rule I have set up loops through the
table and sets the entry in the XML file to the final figure that it finds in
the table.

Any ideas on how I could fix this?
.

Relevant Pages

  • error msg "worker threaded, reported failure, class not regestered in biztalk
    ... I am just learning to use BizTalk to transfer xml file into EDI 835 xml ... SQL server 2003 and BizTalk Adapter for SQL ... The operation was: CoCreatedInstance(CLSID_SQLWorker the worker thread ...
    (microsoft.public.biztalk.general)
  • Re: 1.5 MB input file generates 940MB of data in BizTalkMsgBoxDb
    ... I ran the following interchange on an XML file I worked on a while back: ... Initial Size of Msgbox DB Sql Data File -> 35 MB ... Size of files read from Sql Server Management Studio (Database properties ... Look at the Sql Server Agent jobs set up by Biztalk. ...
    (microsoft.public.biztalk.general)
  • Re: Config file for Biztalk processes - Best practice
    ... This article refers to Biztalk 2004, but it should be close enough to ... 'Config files' are doable but reading them each time the orch runs ... zeno wrote: ... data from the xml file and puts it in a request message to a web ...
    (microsoft.public.biztalk.general)
  • Re: Breaking up a large message
    ... XML file that is structured correctly. ... above format as this is the normal XML format that BizTalk 2004 produces! ... Kam ...
    (microsoft.public.biztalk.general)
  • Re: Can I ask a question?
    ... BizTalk Server can be overkill for some simple situations that you might ... > somehow) the XML file. ... So Biztalk picks this file up and based on the XML ... > files I provided for both destination and source and the mapping I have to ...
    (microsoft.public.biztalk.general)