Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayTOKENCOUNT (SSIS Expression)
Applies to: 
SQL Server
SSIS Integration Runtime in Azure Data Factory
Returns the number of tokens in a string that contains tokens separated by the specified delimiters.
TOKENCOUNT(character_expression, delimiter_string)
character_expression
A string that contains tokens separated by delimiters.
delimiter_string
A string that contains delimiter characters. For example, "; ," contains three delimiter characters semi-colon, a blank space, and a comma.
DT_I4
The following remarks apply to the TOKEN function:
The delimiter string can contain one or more delimiter characters.
Leading delimiters are skipped.
TOKENCOUNT works only with the DT_WSTR data type. A character_expression argument that is a string literal or a data column with the DT_STR data type is implicitly cast to the DT_WSTR data type before TOKEN performs its operation. Other data types must be explicitly cast to the DT_WSTR data type.
TOKENCOUNT returns 0 (zero) if the character_expression is null.
You can use variables and columns as arguments for this expression.
In the following example, the TOKENCOUNT function returns 3 because the string contains three tokens: "01", "12", "2011".
TOKENCOUNT("01/12/2011", "/")
In the following example, the TOKENCOUNT function returns 4 because there are four tokens ("a", "little", "white", "dog").
TOKENCOUNT("a little white dog"," ")
In the following example, the TOKENCOUNT function returns 1. The function parses the input string for delimiters and since there are none in the string, it just adds the entire string as the first token.
TOKENCOUNT("a little white dog","|")
In the following example, the TOKENCOUNT function returns 4. The delimiter string in this example contains 5 delimiters. The input string contains 4 tokens: "a", "little", "white", "dog".
TOKENCOUNT("a:little|white dog","| ,.:")
In the following example, the TOKENCOUNT function returns 4. It ignores all the leading space characters.
TOKENCOUNT(" a little white dog", " ")