DynamicPropertiesTaskAssignment Object

DTS Programming

DTS Programming

DynamicPropertiesTaskAssignment Object

The DynamicPropertiesTaskAssignment object holds the definition of a single package object property to be modified by a Dynamic Properties Task object, and the source of the new property value.

Collections
Properties Collection
Properties
DestinationPropertyID Property SourceIniFileKey Property
SourceConstantValue Property SourceIniFileSection Property
SourceDataFileFileName Property SourceQueryConnectionID Property
SourceEnvironmentVariable Property SourceQuerySQL Property
SourceGlobalVariable Property SourceType Property
SourceIniFileFileName Property  

Methods
Reset Method

Remarks

One of the following sources for the new property value can be specified:

  • A constant

  • The contents of a data file

  • An environment variable

  • A Data Transformation Services (DTS) global variable

  • A field in an .ini file

  • An SQL query

See Also

DynamicPropertiesTask

DynamicPropertiesTaskAssignments Collection