DtsContainer.Variables Property

Artikkeli
12/03/2008

Returns a collection that contains the variables associated with this container. This property is read-only.

Namespace: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)

Syntax

'Declaration
Public ReadOnly Property Variables As Variables

public Variables Variables { get; }

public:
property Variables^ Variables {
    Variables^ get ();
}

/** @property */
public Variables get_Variables ()

public function get Variables () : Variables

Property Value

A Variables collection.

Example

The following example creates a package, and adds a variable, myVar, to the variable collection. The Package has use of the Variables collection through its inheritance of DtsContainer.

static void Main(string[] args)
        {
            Package p = new Package();
            //Add a variable, ,myvar, to the package variables
            // collection with a value of 5, in the myNamespace
            // namespace
            Variable var = p.Variables.Add("myVar", false, "myNamespace", 5);
            //
            // rest of code here...
            //
        }

Shared  Sub Main(ByVal args() As String)
            Dim p As Package =  New Package() 
            'Add a variable, ,myvar, to the package variables
            ' collection with a value of 5, in the myNamespace
            ' namespace
            Dim var As Variable =  p.Variables.Add("myVar",False,"myNamespace",5) 
            '
            ' rest of code here...
            '
End Sub

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms