Sequence.Properties Property
Returns a collection of DtsProperty objects that contain properties relating to the sequence container.
Espacio de nombres: Microsoft.SqlServer.Dts.Runtime
Ensamblado: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)
Sintaxis
'Declaración
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
Valor de propiedad
A DtsProperties collection.
Ejemplo
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
Seguridad para subprocesos
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.
Plataformas
Plataformas de desarrollo
Para obtener una lista de las plataformas compatibles, vea Requisitos de hardware y software para instalar SQL Server 2005.
Plataformas de destino
Para obtener una lista de las plataformas compatibles, vea Requisitos de hardware y software para instalar SQL Server 2005.
Vea también
Referencia
Sequence Class
Sequence Members
Microsoft.SqlServer.Dts.Runtime Namespace