Sequence.Properties Property

Article
12/15/2008

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

Espace de noms: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)

Syntaxe

'Déclaration
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

Valeur de propriété

A DtsProperties collection.

Exemple

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

Sécurité des threads

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.

Plateformes

Plateformes de développement

Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.

Plateformes cibles

Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.

Voir aussi

Référence

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

Partager via