Write an BeforeEachRowSet event handler to take specific action before the XML transform component starts translating a dataset. This can be a nested detail set, or the entire XML data packet.  

For example, you can use BeforeEachRowSet with the AfterEachRowSet 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 

AfterEachRowSet 

BeforeEachRow 

Data