New SSIS Functions in Denali

Four New functions are included in Denali for SSIS.

Function	Example	Output
LEFT	LEFT(“Denali,3)	Den
TOKEN	TOKEN(“SQL Server 2012”,” “ ,2)	Server
TOKENCOUNT	TOKENCOUNT(“SQL Server 2012”,” “ )	3
REPLACENULL	REPLACENULL(NULL,2)	2