Sequence.Properties Property

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

命名空间: Microsoft.SqlServer.Dts.Runtime
程序集: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)

语法

声明
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

属性值

A DtsProperties collection.

示例

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

线程安全

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.

平台

开发平台

有关支持的平台列表，请参阅安装 SQL Server 2005 的硬件和软件要求。

目标平台

有关支持的平台列表，请参阅安装 SQL Server 2005 的硬件和软件要求。

请参阅

参考

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