Using Property Expressions to Specify Property Values for Data Flow Objects

The values of certain properties of data flow objects can be specified by using property expressions available on the Data Flow task container.

For information about using property expressions, see Using Property Expressions in Packages.

You can use property expressions to customize configurations for each deployed instance of a package. You can also use property expressions to specify run-time constraints for a package by using the /set option with the dtexec command prompt utility. For example, you can constrain the MaximumThreads used by the Sort transformation, or the MaxMemoryUsage of the Fuzzy Grouping and Fuzzy Lookup transformations. If unconstrained, these transformations may cache large amounts of data in memory.

Creating Expressions for Properties of Data Flow Objects

To specify a property expression for one of the properties of data flow objects listed in this topic, display the Properties window for the Data Flow task by selecting the Data Flow task on the Control Flow surface of the designer, or by selecting the Data Flow tab of the designer without selecting any individual component or path. Select the Expressions property and click the ellipsis (...) to display the Property Expressions Editor dialog box. Drop down the Property list to select a property, then type an expression in the Expression text box, or click the ellipsis (...) to display the Expression Builder dialog box.

The Property list displays available properties for only those data flow objects that you have already placed on the Data Flow surface of the designer. Therefore, you cannot use the Property list to view all the possible properties of data flow objects that support property expressions. For example, if you have placed a DataReader Source on the designer surface, the Property list contains an entry for the [DataReader Source].[SqlCommand] property. The list also displays many properties of the Data Flow task itself.

Properties of Data Flow Objects That Support Property Expressions

The values of the properties in the following list can be specified by using property expressions.

Data Flow Sources

Data Flow object Property

DataReader source

SqlCommand property

XML source

XMLData property

XMLSchemaDefinition property

Data Flow Transformations

Data Flow object Property

Conditional Split transformation

FriendlyExpression property

Derived Column transformation

FriendlyExpression property

Fuzzy Grouping transformation

MaxMemoryUsage property

Fuzzy Lookup transformation

MaxMemoryUsage property

OLE DB Command transformation

SqlCommand property

Percentage Sampling transformation

SamplingValue property

Pivot transformation

PivotKeyValue property

Row Sampling transformation

SamplingValue property

Sort transformation

MaximumThreads property

Unpivot transformation

PivotKeyValue property

Data Flow Destinations

Data Flow object Property

Flat File destination

Header property

SQL Server 2005 Compact Edition destination

TableName property

See Also


Common Properties
Source Custom Properties
Transformation Custom Properties
Destination Custom Properties
Path Properties

Other Resources

Using Property Expressions in Packages

Help and Information

Getting SQL Server 2005 Assistance

Change History

Release History

5 December 2005

New content:
  • Added explanation of where and how property expressions are entered for data flow components that support them.