Integration Services Expression Concepts

This section summarizes the expression syntax, explains the use and implicit conversion of SSIS data types in expressions, and describes how the expression evaluator handles string padding and truncation.

The following table describes the topics in this section.

Topic Description

Syntax (SSIS)

Summarizes expression evaluator syntax.

Data Type Conversion in Expressions

Explains the rules for converting data from one data type to a different one.

Data Truncation (SSIS)

Describes how the expression evaluator handles truncation of data values.

String Padding (SSIS)

Describes how the expression evaluator compares strings that contain spaces.

Literals (SSIS)

Describes the numeric, string, and Boolean literals that the expression evaluator supports.

Identifiers (SSIS)

Describes the use of regular and qualified identifiers.