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 records is used to match children to parents. As each parent record is processed from one input, the associated children records are processed from the other input.
To mark the end of children associated with a parent, a blank row (all NULLs) much be present in the input. The processing of a parent record is only completed when a blank row is encountered at the end of the children for that parent. The final record in the children input must be a blank row in order to complete the processing. You can use Query transform to prepare child data with the proper blank rows.
For additional information about modelling of composite records in SSIS+, please refer to this article.
Book a Presales Call
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 Netsuite destination component.
The composite record input accepts sets of rows, one set for each parent record. Each set of rows must be separated with blank row (all NULLs). The parent record will not finish processing its record, until all composite record children have received ...How to work with composite records handling in a rest destination component.
The composite record input accepts sets of rows, one set for each parent record. Each set of rows must be separated with blank row (all NULLs). The parent record will not finish processing its record, until all composite record children have received ...How to work with composite records handling in a Sage destination component.
The composite record input accepts sets of records, one set for each parent record. Each set of records must be separated with blank row (all NULLs). The parent record will not finish processing its record, until all composite record children have ...How to work with composite records handling in a QuickBooks destination component.
The composite record input accepts sets of records, one set for each parent record. Each set of records must be separated with a blank row (all NULLs). The parent object will not finish processing its record until all composite object children have ...