Composite records handling
The composite object output contains not only properties from the composite record, but also the parent record. 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.
Book a Presales Call
Are you new to COZYROC and evaluating our solutions?
Book a Presales Call with us now and get 5% off SSIS+.
Book a Presales Call with us now and get 5% off SSIS+.
Related Articles
How to work with composite records handling in a Dynamics GP source component.
The composite object output contains not only properties from the composite record, but also the parent record. 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 ...How to work with composite records handling in a Dynamic GP destination component.
When working with composite records, one input must be set up which contains the main objects (parents) and a separate input must be set up which contains the related composite objects (children). The order of the parent records and the children ...How to work with composite records handling in a Netsuite source component.
The composite record output contains not only fields from the composite record, but also the parent records. The output will be populated with sets of rows, one set for each parent record. Each set of rows is separated with blank row (all NULLs). For ...How to work with composite records handling in a REST source component.
The composite record output contains not only fields from the composite record, but also the parent records. The output will be populated with sets of rows, one set for each parent record. Each set of rows is separated with blank row (all NULLs). ...Dynamics GP Source: How to modify source object criteria dynamically at runtime
The source object criteria are available in the data flow properties list. Follow these steps to set up an expression: Create a variable that can be loaded with the desired ObjectCriteriaXML. Right-click on the data flow canvas and select ...