Sunday, January 22, 2012

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

No comments:

Post a Comment