DTS Programming
SourceEnvironmentVariable Property
The SourceEnvironmentVariable property sets or returns the name of an environment variable that contains the value to which a Data Transformation Services (DTS) package object property will be set by the DynamicPropertiesTask object, when the SourceType property is DTSDynamicPropertiesSourceType_EnvironmentVariable.
Applies To
| DynamicPropertiesTaskAssignment Object |
Syntax
object.SourceEnvironmentVariable [= name]
| Part | Description |
|---|---|
| object | Expression that evaluates to a DynamicPropertiesTaskAssignment object |
| name | Name of environment variable containing value to which a DTS package object property will be set |
Data Type
String
Modifiable
Read/write
Prototype (C/C++)
HRESULT SourceEnvironmentVariable(BSTR* pRetVal);
HRESULT SourceEnvironmentVariable(BSTR pRetVal);
Remarks
Only system environment variables can be referenced with this property.
Example
The following example sets the SourceEnvironmentVariable property to a name:
oAssign.SourceEnvironmentVariable = "DTS_UE_Env"