Dynamic Properties Task Properties

DTS Designer

DTS Designer Help

Dynamic Properties Task Properties

Use this tab to view the package properties that will be assigned at Data Transformation Services (DTS) package run time.

Description

Type a description of the Dynamic Properties task. This description appears on the DTS Designer design sheet.

Destination Property

View the name of the package property whose value will be assigned at run time.

Source Type

Select one of the following external sources from which a property value is assigned:

An .ini file

A data file

A query

A global variable

An environment variable

A constant

Source Value

View the current value of the property, which may change each time the package is run.

Add

Display the Package Properties dialog box, where you can select a new package property to assign a value dynamically.

Edit

Click to change the dynamic assignment of a selected property in the Change list.

Delete

Click to permanently remove a dynamic property assignment from the Change list.

See Also

Dynamic Properties Task