|
Home > Archive > BizTalk Server > May 2004 > Batching the orchestration process
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Batching the orchestration process
|
|
|
| How to get multiple rows from the sql adapter and then do the orchestration process like the transformation of data etc. for each row? How do we loop through the same process for each row. I appreciate any help in advance.
| |
| Ehab Sobhy 2004-05-17, 2:39 pm |
| A simple way is to make a request response SQL port (send - receive) and
you send to a stored procedure that will return you the rows you are asking
for,
When you write the stored procedure use " FOR XML AUTO , XMLDATA" at the
beginning, then use the BTS SQL wizard to point to that stored procedure,
then it will generate for you an XML schema with two root nodes , one for
calling the stored procedure and the other for the returning data ( which
will have some fields set as repetitive since many rows can return), use
these schemas within your orchestration. At runtime remember to make the
stored procedure only using " FOR XML AUTO".
| |
|
| thanks for the response.
Once I get the multiple rows, How do I loop through the orchestration process for each row. I want to process all the rows. Right now I have the business process defined for a single row. How do I make it run for multiple rows at a given time.
| |
| Ehab Sobhy 2004-05-17, 4:38 pm |
| Well, there are lots of ways to do so, one way would be to set the
returning message to an XMLDocument local variable and using XML DOM you
can get the rows count or Iterate in them or extract parts and then you
can set some kind of a loop. one other way i think of is to use the maper
and use a funcktoids like the index, record count or the iterator to
achieve your goal.
| |
| Ehab Sobhy 2004-05-17, 8:37 pm |
| A simple way is to make a request response SQL port (send - receive) and
you send to a stored procedure that will return you the rows you are asking
for,
When you write the stored procedure use " FOR XML AUTO , XMLDATA" at the
beginning, then use the BTS SQL wizard to point to that stored procedure,
then it will generate for you an XML schema with two root nodes , one for
calling the stored procedure and the other for the returning data ( which
will have some fields set as repetitive since many rows can return), use
these schemas within your orchestration. At runtime remember to make the
stored procedure only using " FOR XML AUTO".
|
|
|
|
|