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 received a blank row to indicate completion of the composite records. You can use Query transform to prepare child data with the proper blank rows. See also the demonstration video for an example of creating records containing composite data.
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 QuickBooks 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 records, one set for each parent record. Each set of records is separated with a blank row (all ...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 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 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 ...