DEPRECATED: Starting with SSIS+ 1.9, the .NET scripts are no longer maintained. Use the provided JavaScript alternative scripts instead.
Script File:
Overview
Data flow transformation, which can split a row based on column value into multiple data flow rows.
Setup
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 for implementing parameters user interface.
Requires installation of COZYROC SSIS+ 1.4 library.
Sample
If you have the following input row:
| 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 |
Related technology
- To do the reverse transformation, check Join Column Transformation script.