My previous sample will generate one file for output
so if my SP will return many records the result will be the same and in one output
file I will get many records.

In some cases you will need to debatch/disassemble the result and for each record
to have one separate file.

There are two ways to solve the issue
1. make disassembler changing the structure of the generated XSD
2. make loop in orchestration and retrieve records with indexer using XPath

In my next post I will show the 2nd option even it is not the best solution.
Using disassembler will work many times faster if you have many records!

Comments

Popular posts from this blog

How to poll database using WCF-SQL adapter

SQL query timeout from application but works fast from SSMS