The DynamicPropertiesTaskSourceType constants are used with the SourceType property to specify the type of source object that provides the value to which a Data Transformation Services (DTS) package object property will be set by the DynamicPropertiesTask object.
| Symbol | Value | Description |
|---|---|---|
| DTSDynamicPropertiesSourceType_Constant | 4 | Source is a constant. |
| DTSDynamicPropertiesSourceType_DataFile | 5 | Source is the contents of a data file. |
| DTSDynamicPropertiesSourceType_EnvironmentVariable | 3 | Source is the value of a system environment variable. |
| DTSDynamicPropertiesSourceType_GlobalVariable | 2 | Source is the value of a Data Transformation Services (DTS) global variable within the package. |
| DTSDynamicPropertiesSourceType_IniFile | 0 | Source is the value of a key within an .ini file. |
| DTSDynamicPropertiesSourceType_Query | 1 | Source is a value returned by an SQL query. |