How to work with composite records handling in a Sage source component.

How to work with composite records handling in a Sage source component.

The composite record output contains not only properties from the composite entity, but also the parent entities. The output will be populated with sets of records, one set for each parent record. Each set of records is separated with blank row (all NULLs).

For additional information about modelling of composite records in SSIS+, please refer to this article.