Sequence.Properties Property

Articolo
12/15/2008

Returns a collection of DtsProperty objects that contain properties relating to the sequence container.

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 code example creates a Sequence object, then retrieves the Properties collection, iterating and displaying the names and property kinds found in the collection.

using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.SqlServer.Dts.Runtime;

namespace Microsoft.SqlServer.SSIS.Samples
{
    class Program
    {
        static void Main(string[] args)
        {
            Package package = new Package();
            Sequence seq = (Sequence)package.Executables.Add("STOCK:SEQUENCE");
            DtsProperties seqProps = seq.Properties;

            foreach (DtsProperty pc in seqProps)
            {
                Console.WriteLine("Name: {0}, Property Kind {1}", pc.Name, pc.PropertyKind);
            }
        }
    }
}

Imports System
Imports System.Collections.Generic
Imports System.Text
Imports Microsoft.SqlServer.Dts.Runtime
 
Namespace Microsoft.SqlServer.SSIS.Samples
    Class Program
        Shared  Sub Main(ByVal args() As String)
            Dim package As Package =  New Package() 
            Dim seq As Sequence = CType(package.Executables.Add("STOCK:SEQUENCE"), Sequence)
            Dim seqProps As DtsProperties =  seq.Properties 
 
            Dim pc As DtsProperty
            For Each pc In seqProps
                Console.WriteLine("Name: {0}, Property Kind {1}", pc.Name, pc.PropertyKind)
            Next
        End Sub
    End Class
End Namespace

Sample Output:

Name: CreationName, Property Kind Other

Name: DelayValidation, Property Kind Other

Name: Description, Property Kind Other

Name: Disable, Property Kind Other

Name: DisableEventHandlers, Property Kind Other

Name: EventHandlers, Property Kind Other

Name: EventInfos, Property Kind Other

Name: Executables, Property Kind Other

Name: ExecutionDuration, Property Kind Other

Name: ExecutionResult, Property Kind Other

Name: ExecutionStatus, Property Kind Other

Name: FailPackageOnFailure, Property Kind Other

Name: FailParentOnFailure, Property Kind Other

Name: ForcedExecutionValue, Property Kind Other

Name: ForceExecutionResult, Property Kind Other

Name: ForceExecutionValue, Property Kind Other

Name: ID, Property Kind Other

Name: IsDefaultLocaleID, Property Kind Other

Name: IsolationLevel, Property Kind Other

Name: LocaleID, Property Kind Other

Name: LogEntryInfos, Property Kind Other

Name: LoggingMode, Property Kind Other

Name: LoggingOptions, Property Kind Other

Name: MaximumErrorCount, Property Kind Other

Name: Name, Property Kind Other

Name: Parent, Property Kind Other

Name: PrecedenceConstraints, Property Kind Other

Name: StartTime, Property Kind Other

Name: StopTime, Property Kind Other

Name: TransactionOption, Property Kind Other

Name: VariableDispenser, Property Kind Other

Name: Variables, Property Kind Other

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

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

Condividi tramite