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.

See Also

Tasks

Using Expressions in Packages

Concepts

Integration Services Data Types
Advanced Integration Services Expressions

Other Resources

Operators (SSIS)
Functions (SSIS)

Help and Information

Getting SQL Server 2005 Assistance