Variable.Properties Property

Returns a collection of DtsProperty objects. This property is read-only.

Spazio dei nomi: Microsoft.SqlServer.Dts.Runtime
Assembly : Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)

Sintassi

'Dichiarazione
Public ReadOnly Property Properties As DtsProperties

public DtsProperties Properties { get; }

public:
virtual property DtsProperties^ Properties {
    DtsProperties^ get () sealed;
}

/** @property */
public final DtsProperties get_Properties ()

public final function get Properties () : DtsProperties

Valore proprietà

A DtsProperties collection.

Esempio

The following example creates a package and adds a variable to the Variables collection. It then loops through the DtsProperties collection and displays the name of each property in the collection.

static void Main(string[] args)
            {
                Package p = new Package();
                Variable v = p.Variables.Add("x", false, "", 1);
                int vCount =  v.Properties.Count;
                Console.WriteLine("Number of properties in a variable = {0}", vCount);
                DtsProperties vProps = v.Properties;
                foreach (DtsProperty vProp in vProps)
                    Console.WriteLine(vProp.Name);
            }

Shared  Sub Main(ByVal args() As String)
                Dim p As Package =  New Package() 
                Dim v As Variable =  p.Variables.Add("x",False,"",1) 
                Dim vCount As Integer =  v.Properties.Count 
                Console.WriteLine("Number of properties in a variable = {0}", vCount)
                Dim vProps As DtsProperties =  v.Properties 
                Dim vProp As DtsProperty
                For Each vProp In vProps
                    Console.WriteLine(vProp.Name)
                Next
End Sub

Sample Output:

Number of properties in a variable = 12

CreationName

DataType

Description

EvaluateAsExpression

ID

Name

Namespace

QualifiedName

RaiseChangedEvent

ReadOnly

SystemVariable

Value

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.

Piattaforme

Piattaforme di sviluppo

Per un elenco delle piattaforme supportate, vedere Requisiti hardware e software per l'Installazione di SQL Server 2005.

Piattaforme di destinazione

Per un elenco delle piattaforme supportate, vedere Requisiti hardware e software per l'Installazione di SQL Server 2005.

Vedere anche

Riferimento

Variable Class
Variable Members
Microsoft.SqlServer.Dts.Runtime Namespace