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.

In This Section

• Syntax (SSIS)
  Summarizes expression evaluator syntax.

• Integration Services Data Types in Expressions
  Summarizes the use of data types in expressions.

• Implicit 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.

See Also

Tasks

Using Expressions in Packages

Concepts

Integration Services Data Types

Advanced Integration Services Expressions

Other Resources

Operators (SSIS Expression)

String Functions and Other Functions (SSIS Expression)