Composition Component
via SSIS Productivity Pack
Combine multiple rows of data into one based on a key field value with the Composition Component, found within the SSIS Productivity Pack.
Download Purchase
What other productivity tools are available?
Click here for more solutions.
The Composition component is a data flow transformation component that can be used to combine/merge multiple rows into one row based on a key field value.
Developer Productivity Tools
Composition Component
The Composition Component, part of the SSIS Productivity Pack, offers developers three destination types including Delimited Text, JSON Array, and, XML Elements.
With the Delimited Text, developers can choose the delimiter as well as the text qualifier. With the XML Elements, developers can select the Root Element Name, Child Element Name, and, the Output Column Settings.
Easily Combine Data Rows
The Composition Component is a powerful SSIS data flow transformation that allows you to merge multiple rows into a single row based on a specified key field. Whether working with delimited text, JSON arrays, or XML elements, the component offers flexible options to transform your data exactly as you need it, without writing a single line of code.
Built on the Microsoft SQL Server Integration Services (SSIS) platform, it leverages the performance, flexibility, and familiar drag-and-drop design environment your team already knows. Configure key columns, skip duplicates or NULL values, and fine-tune formatting with user-friendly settings that give you full control over your data composition process.
The Composition Component is included in the Conversion Components of our Productivity Pack, a large collection of premium and unique ETL tools to enable greater development productivity. We also offer several additional connectivity solutions to easily integrate Composition with applications such as Microsoft Dynamics 365, SharePoint, Salesforce, and many more.
See our full product offerings for more information.
More Conversion Components
Our Data Conversion Components simplify the process of transforming and integrating data within your ETL workflows. Each component is purpose-built to extend and enhance data migration and integration capabilities. In addition to the Composition Component, our Conversion Components include:
Decomposition
