Write an AfterEachRowSet event handler to take specific action after the XML transform component has translated an entire dataset. This can be a nested detail set, or the entire XML data packet.  

For example, you can use AfterEachRowSet with the BeforeEachRowSet and OnTranslate methods to compute summary values: initialize a variable in the BeforeEachRowSet method, update it for every OnTranslate event, and use the result in the AfterEachRowSet event. 

TransformXML 

AfterEachRow 

BeforeEachRow 

Data