+ (Concatenate) (SSIS Expression)
Applies To: SQL Server 2016
Concatenates two expressions into one expression.
character_expression1 + character_expression2
Is any valid DT_STR, DT_WSTR, DT_TEXT, DT_NTEXT, or DT_IMAGE data type expression.
The expression can use either or both of the DT_STR and DT_WSTR data types.
The concatenation of the DT_STR and DT_WSTR data types returns a result of the DT_WSTR type. The length of the string is the sum of the lengths of the original strings expressed in characters.
Only data with the string data types DT_STR and DT_WSTR or the Binary Large Object Block (BLOB) data types DT_TEXT, DT_NTEXT, and DT_IMAGE can be concatenated. Other data types must be explicitly converted to one of these data types before concatenation occurs. For more information about legal casts between data types, see Cast (SSIS Expression).
Both expressions must be of the same data type, or one expression must be implicitly convertible to the data type of the other expression. For example, if the string "Order date is " and the column OrderDate are concatenated, the values in OrderDate are implicitly converted to a string data type. To concatenate two numeric values, both numeric values must be explicitly cast to a string data type.
A concatenation can use only one BLOB data type: DT_TEXT, DT_NTEXT, or DT_IMAGE.
If either element is null, the result is null.
String literals must be enclosed in quotation marks.
This example concatenates the values in the FirstName and LastName columns and inserts a space between them.
FirstName + ' ' + LastName
This example concatenates the variables ZIPCode and ZIPCode+4. Both variables have a string data type. ZIPCode+4 must be enclosed in brackets because the variable name includes the + character.
@ZIPCcode + "-" + @[ZipCode+4]