DEPRECATED: Starting with SSIS+ 1.9, the .NET scripts are no longer maintained. Use the provided JavaScript alternative scripts instead.
No votes yet


Data flow transformation, which can combine multiple rows based on grouping column into single data flow row.


The script has the following parameters:

  • GroupColumn - selects input grouping column.
  • JoinColumn - selects input join column.
  • JoinSymbol - specifies join symbol. It can be regular expression.


Depends on COZYROC Script Component Plus for implementing parameters user interface.
Requires installation of COZYROC SSIS+ 1.4 library.


If you have the following input rows:

Column1 Column2 Column3
1 2 5
1 3 5
1 4 5

By selecting Column1 for GroupColumn, Column2 for JoinColumn and ; for JoinSymbol you will get the following output row:

Column1 Column2 Column3
1 2;3;4 5

Related technology

Library references

  • System
  • System.Data
  • Microsoft.SqlServer.TxScript
  • Microsoft.SqlServer.PipelineHost
  • Microsoft.SqlServer.DTSPipelineWrap
  • Microsoft.SqlServer.DTSRuntimeWrap
  • Microsoft.SqlServer.ManagedDTS
  • CozyRoc.SSISPlus