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"