How to work with composite records handling in a MongoDB source component.
For each array in the document, regardless of the depth of nesting, there will be created a composite output that enables retrieving the field values of its items. This output contains not only the fields of the array items, but also the fields from all parent record(s).
During runtime, the output will be populated with sets of rows, one set for each parent record. Each set of rows is separated with a blank row (all NULLs). Those blank rows are used for recreating the parent-child relationships in all SSIS+ components that support composite inputs (e.g. MongoDB Destination ). Tip: If you don't need the blank rows, you can set up the standard Conditional Split component to filter them out.
For additional information about modelling of composite records in SSIS+, please refer to this article.