CozyRocOverview
Data flow transformation, which can split a row based on column value into multiple data flow rows. For example if you have the following input rows:
| Column1 | Column2 | Column3 |
|---|---|---|
| 1 | 2;3;4 | 5 |
By selecting Column2 for SplitColumn and ; for SplitSymbol you will get the following output rows:
| Column1 | Column2 | Column3 |
|---|---|---|
| 1 | 2 | 5 |
| 1 | 3 | 5 |
| 1 | 4 | 5 |
The script has the following parameters:
- SplitColumn – selects column containing value to be split.
- SplitSymbol – specifies split symbol. It can be regular expression.
Requirements
Depends on CozyRoc Script Component Plus component for implementing parameters user interface.
Requires installation of CozyRoc SSIS+ 1.4 library.
Library references
- System
- System.Data
- Microsoft.SqlServer.TxScript
- Microsoft.SqlServer.PipelineHost
- Microsoft.SqlServer.DTSPipelineWrap
- Microsoft.SqlServer.DTSRuntimeWrap
- Microsoft.SqlServer.ManagedDTS
- CozyRoc.SSISPlus