'SSIS Visual Studio select only some rows based on length of expression
I need to find a transformation which will help me select only the red rows from this Excel table in SSIS Visual Studio (2017).
The output table is supposed to have 2 columns, 14 rows. In the first column, the rows I want to select always have LEN=5 and start with CZ0 (the 2 following numbers differ)... and then I need to add the 5th column with corresponding rows.
I tried Derived Column, Conditional Split, Merge Join etc. in various combinations but nothing seems to work.
Table to select from
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|