SequenceClass Class

Definition

Represents a sequence class.

public ref class SequenceClass : Microsoft::SqlServer::Dts::Runtime::Wrapper::IDTSBreakpointSite100, Microsoft::SqlServer::Dts::Runtime::Wrapper::IDTSEventsProvider100, Microsoft::SqlServer::Dts::Runtime::Wrapper::IDTSExecutable100, Microsoft::SqlServer::Dts::Runtime::Wrapper::IDTSExecutionMetrics100, Microsoft::SqlServer::Dts::Runtime::Wrapper::IDTSName100, Microsoft::SqlServer::Dts::Runtime::Wrapper::IDTSPersist100, Microsoft::SqlServer::Dts::Runtime::Wrapper::IDTSPropertiesProvider100, Microsoft::SqlServer::Dts::Runtime::Wrapper::IDTSRuntimeObject100, Microsoft::SqlServer::Dts::Runtime::Wrapper::IDTSSequence100, Microsoft::SqlServer::Dts::Runtime::Wrapper::Sequence
[System.Runtime.InteropServices.ClassInterface(System.Runtime.InteropServices.ClassInterfaceType.None)]
[System.Runtime.InteropServices.Guid("79311620-29A0-4811-998E-806847F6FBF8")]
[System.Runtime.InteropServices.TypeLibType(System.Runtime.InteropServices.TypeLibTypeFlags.FCanCreate)]
public class SequenceClass : Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSBreakpointSite100, Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSEventsProvider100, Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSExecutable100, Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSExecutionMetrics100, Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSName100, Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSPersist100, Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSPropertiesProvider100, Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSRuntimeObject100, Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSSequence100, Microsoft.SqlServer.Dts.Runtime.Wrapper.Sequence
[System.Runtime.InteropServices.ClassInterface(System.Runtime.InteropServices.ClassInterfaceType.None)]
[System.Runtime.InteropServices.TypeLibType(System.Runtime.InteropServices.TypeLibTypeFlags.FCanCreate)]
[System.Runtime.InteropServices.Guid("2292B7AB-227F-4EFD-99ED-60D3D716CB87")]
public class SequenceClass : Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSBreakpointSite100, Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSEventsProvider100, Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSExecutable100, Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSExecutionMetrics100, Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSName100, Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSPersist100, Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSPropertiesProvider100, Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSRuntimeObject100, Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSSequence100, Microsoft.SqlServer.Dts.Runtime.Wrapper.Sequence
[System.Runtime.InteropServices.ClassInterface(System.Runtime.InteropServices.ClassInterfaceType.None)]
[System.Runtime.InteropServices.TypeLibType(System.Runtime.InteropServices.TypeLibTypeFlags.FCanCreate)]
[System.Runtime.InteropServices.Guid("2323159B-EAF9-4F86-9D20-9CBF7C64228D")]
public class SequenceClass : Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSBreakpointSite100, Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSEventsProvider100, Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSExecutable100, Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSExecutionMetrics100, Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSName100, Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSPersist100, Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSPropertiesProvider100, Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSRuntimeObject100, Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSSequence100, Microsoft.SqlServer.Dts.Runtime.Wrapper.Sequence
[<System.Runtime.InteropServices.ClassInterface(System.Runtime.InteropServices.ClassInterfaceType.None)>]
[<System.Runtime.InteropServices.Guid("79311620-29A0-4811-998E-806847F6FBF8")>]
[<System.Runtime.InteropServices.TypeLibType(System.Runtime.InteropServices.TypeLibTypeFlags.FCanCreate)>]
type SequenceClass = class
    interface Sequence
    interface IDTSContainer100
    interface IDTSSequence100
    interface IDTSExecutable100
    interface IDTSEventsProvider100
    interface IDTSExecutionMetrics100
    interface IDTSPropertiesProvider100
    interface IDTSName100
    interface IDTSBreakpointSite100
    interface IDTSSuspend100
    interface IDTSPersist100
    interface IDTSRuntimeObject100
[<System.Runtime.InteropServices.ClassInterface(System.Runtime.InteropServices.ClassInterfaceType.None)>]
[<System.Runtime.InteropServices.TypeLibType(System.Runtime.InteropServices.TypeLibTypeFlags.FCanCreate)>]
[<System.Runtime.InteropServices.Guid("2292B7AB-227F-4EFD-99ED-60D3D716CB87")>]
type SequenceClass = class
    interface Sequence
    interface IDTSContainer100
    interface IDTSSequence100
    interface IDTSExecutable100
    interface IDTSEventsProvider100
    interface IDTSExecutionMetrics100
    interface IDTSPropertiesProvider100
    interface IDTSName100
    interface IDTSBreakpointSite100
    interface IDTSSuspend100
    interface IDTSPersist100
    interface IDTSRuntimeObject100
[<System.Runtime.InteropServices.ClassInterface(System.Runtime.InteropServices.ClassInterfaceType.None)>]
[<System.Runtime.InteropServices.TypeLibType(System.Runtime.InteropServices.TypeLibTypeFlags.FCanCreate)>]
[<System.Runtime.InteropServices.Guid("2323159B-EAF9-4F86-9D20-9CBF7C64228D")>]
type SequenceClass = class
    interface Sequence
    interface IDTSContainer100
    interface IDTSSequence100
    interface IDTSExecutable100
    interface IDTSEventsProvider100
    interface IDTSExecutionMetrics100
    interface IDTSPropertiesProvider100
    interface IDTSName100
    interface IDTSBreakpointSite100
    interface IDTSSuspend100
    interface IDTSPersist100
    interface IDTSRuntimeObject100
Public Class SequenceClass
Implements IDTSBreakpointSite100, IDTSEventsProvider100, IDTSExecutable100, IDTSExecutionMetrics100, IDTSName100, IDTSPersist100, IDTSPropertiesProvider100, IDTSRuntimeObject100, IDTSSequence100, Sequence
Inheritance
SequenceClass
Attributes
Implements

Remarks

For more information, see Sequence.

Constructors

SequenceClass()

Initializes a new instance of the SequenceClass class.

Properties

CreationName

Gets the string that is used to create an instance of the DtsContainer object.

DebugMode

Gets or sets a value that indicates whether the DtsContainer object is in debug mode.

DelayValidation

Gets or sets a value that indicates whether validation of the task is delayed until run time.

Description

Gest or sets the description of the DtsContainer object.

Disable

Gets or sets a value that indicates whether the DtsContainer object is disabled.

DisableEventHandlers

Gets or sets a value that indicates whether the event handlers on task are disabled.

EventHandlers

Gets a collection of event handler objects.

EventInfos

Gets a collection of EventInfo object.

Executables

Gets a collection of executable objects processed by the run-time engine during execution of this Sequence container.

ExecutionDuration

Returns a value that indicates the amount of time that the container spent in execution, in milliseconds.

ExecutionResult

Gets a value that indicates the success or failure of the execution of the DtsContainer object.

ExecutionStatus

Gets a value that indicates the current status of the execution of the DtsContainer object at the time of the call.

FailPackageOnFailure

Gets or sets a value that indicates whether the package fails when a child container fails.

FailParentOnFailure

Gets or sets a value that indicates whether the parent container fails when a child container fails.

ForcedExecutionValue

Gets or sets an object that contains a container-defined value.

ForceExecutionResult

Gets or sets a DTSForcedExecResult enumeration value that specifies the execution result of the container.

ForceExecutionValue

Gets or sets a value that indicates whether the execution value of the container should be forced to contain a particular value.

ID

Gets a GUID that identifies the DtsContainer.

IDTSSuspend100_SuspendRequired

Gets or sets a value that indicates whether the sequence should suspend.

IsDefaultLocaleID

Gets or sets a value that indicates whether the container uses the default locale.

IsolationLevel

Gets or sets the isolation level of the transaction in the DtsContainer object.

LocaleID

Gets or sets the locale id to use when the DtsContainer object is executed.

LogEntryInfos

Gets a IDTSLogEntryInfos100 object.

LoggingMode

Gets or sets the logging mode of the container.

LoggingOptions

Gets an object that contains properties that indicates the filtering and logging resource for containers.

MaximumErrorCount

Gets or sets the maximum number of errors that can occur before the DtsContainer object stops running.

Name

Gets or sets the name of the DtsContainer.

Parent

Gets the parent container.

PrecedenceConstraints

Gets a collection of IDTSPrecedenceConstraints100.

Properties

Gets a collection of IDTSProperties100.

StartTime

Gets the time that the container began execution.

StopTime

Gets the time that the container ended execution.

SuspendRequired

Gets or sets a value that indicates whether tasks should suspend when they encounter a breakpoint.

TransactionOption

Gets or sets a DTSTransactionOption enumeration value that indicates whether the container participates in transactions.

VariableDispenser

Gets a IDTSVariableDispenser100 object so variables associated with container can be locked.

Variables

Gets a collection that contains the variables associated with this container.

Methods

AcceptBreakpointManager(IDTSBreakpointManager100)

This method is called by the run-time engine when a task or container is created.

ComputeExpressions(Boolean)

Computes expressions of the SequenceClass object.

Execute(IDTSConnections100, IDTSVariables100, IDTSEvents100, IDTSLogging100, Object)

Runs the application.

GetExpression(String)

Returns a string that contains the expression for the specified property.

GetParentID()

Gets or sets the parent identifier of the SequenceClass object.

IDTSSuspend100_get_SuspendRequired()
IDTSSuspend100_ResumeExecution()

Resumes the suspend execution.

IDTSSuspend100_set_SuspendRequired(Boolean)
IDTSSuspend100_SuspendExecution()

Suspends the execution.

LoadFromXML(Object, IDTSEvents100)

Loads a package saves as XML format.

RegenerateID()

Creates a new GUID for the sequence.

ResumeExecution()

Resumes execution of the task after pausing.

SaveToXML(Object, Object, IDTSEvents100)

Saves the package to XML format.

SetExpression(String, String)

Assigns the specified expression to the property.

SuspendExecution()

Called when the executable needs to suspend.

Validate(IDTSConnections100, IDTSVariables100, IDTSEvents100, IDTSLogging100)

Allows the package to determine if it contains invalid settings that will prevent it from executing successfully.

Applies to