Split string and get the count using SSIS

See more:

SQL-Server

SSIS

Hi all,

I am creating a pckage in SSIS in which there is a flatfile source and a destination table. The source contains a string in each row. The string should contain 5 entries delimited with '|' and it looks like this.

a|b|c|d|e

I need to split the string and determine there are 5 entries(delimited with '|') and then insert each entry to the destination table.

The task should fail in case there are less than 5 entries. i.e. a|b|c|d - it fails.

I am able to split the string and insert each entry to the 5 columns in the table. But I am not able to validate the number of entries.

How can I split the string and get the count and verify there 5 entries using SSIS. Please help.

Thanks in advance,