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.
What other applications can you use with Composition?
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.
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.
Composition Component
is available in the
SSIS Productivity Pack
Data Integration Made Easy
Our solution is easy to use, offering code-less integration between the Composition Component and virtually any other application or database system. Our solution is built utilizing Microsoft SQL Server Integration Services (SSIS), a performant and flexible ETL platform, allowing your team to take advantage of the technologies and skills they already have. The drag-and-drop user interface makes it easy to set up powerful integration within a matter of minutes.
Our Composition integration solution is available within the Conversion Components and 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 SSIS Conversion Components
Our Data Conversion Components make it easy to integrate with different services within the ETL process. Each component available has been specifically developed to expand and enhance data migration and integration processes. In addition to Composition Component, the Conversion Components include: