United States (English)

Home Library Learn Samples Downloads Support Community Forums

MSDN Library

Servers and Enterprise Development

SQL Server

SQL Server 2012

Product Documentation

Developer Reference for SQL Server 2012

Developer Reference

Developer's Guide (Integration Services)

Microsoft.SqlServer.Dts.Runtime

ActionOnExistType Enumeration

Application Class

BatchUpgradeOptions Class

BreakpointManager Class

BreakpointTarget Class

BreakpointTargetEnumerator Class

BreakpointTargets Class

Configuration Class

ConfigurationEnumerator Class

Configurations Class

ConnectionEnumerator Class

ConnectionInfo Class

ConnectionInfoEnumerator Class

ConnectionInfos Class

ConnectionManager Class

ConnectionManagerBase Class

ConnectionManagerItem Class

ConnectionManagerItems Class

ConnectionManagerItemState Enumeration

Connections Class

DataTypeInfo Class

DataTypeInfoEnumerator Class

DataTypeInfos Class

DBProviderInfo Class

DBProviderInfoEnumerator Class

DBProviderInfos Class

DefaultEvents Class

DTSBreakpointHitTest Enumeration

DTSCheckpointUsage Enumeration

DtsComException Class

DtsComponentException Class

DTSConfigurationType Enumeration

DtsConnectionAttribute Class

DtsConnectionException Class

DTSConnectionManagerScope Enumeration

DtsContainer Class

DtsConvert Class

DtsCouldNotCreateManagedConnectionException Class

DtsCouldNotCreateManagedForEachEnumeratorException Class

DtsEnumerator Class

DtsErrors Class

DTSEventColumnFilter Structure

DTSEventFilterKind Enumeration

DtsEventHandler Class

DtsEventHandlerEnumerator Class

DtsEventHandlers Class

DtsException Class

DTSExecResult Enumeration

DTSExecStatus Enumeration

DTSExecutionLocation Enumeration

DtsExponentTooLargeException Class

DTSFileConnectionUsageType Enumeration

DTSForcedExecResult Enumeration

DtsForEachEnumeratorAttribute Class

DtsGenericException Class

DtsInvalidBreakpointSiteException Class

DtsInvalidProjectPasswordOrDataException Class

DtsInvalidProjectUserKeyOrDataException Class

DTSLogEntryFrequency Enumeration

DTSLoggingMode Enumeration

DtsLogProviderAttribute Class

DTSManagedXmlSerializationHelper Class

DtsNoConnectionAssignedException Class

DtsNoForEachEnumAssignedException Class

DtsNoLogProviderAssignedException Class

DtsNoObjectAssignedException Class

DtsNotAConnectionException Class

DtsNotAForEachEnumException Class

DtsNotALogProviderException Class

DtsNotAManagedEnumeratorException Class

DtsNoTaskAssignedException Class

DtsNotATaskException Class

DtsObject Class

DTSObjectHostType Enumeration

DTSObjectReferenceType Enumeration

DTSPackageInfoFlags Enumeration

DTSPackageType Enumeration

DTSPipelineComponentType Enumeration

DtsPipelineException Class

DTSPrecedenceEvalOp Enumeration

DTSPriorityClass Enumeration

DTSProductLevel Enumeration

DtsProperties Class

DtsProperty Class

DtsPropertyAttribute Class

DTSPropertyKind Enumeration

DTSProtectionLevel Enumeration

DTSProviderSubType Enumeration

DTSProviderType Enumeration

DTSReadOnlyCollectionBase Class

DtsRuntimeException Class

DtsScriptingException Class

DTSServerParameterType Enumeration

DTSSignatureStatus Enumeration

DtsSqlException Class

DtsTaskAttribute Class

DtsTaskException Class

DtsToolsException Class

DTSTransactionOption Enumeration

DtsWarning Class

DtsWarnings Class

EmptyEnumerator Class

EnumReferencedObjects Class

ErrorEnumerator Class

EventInfo Class

EventInfoEnumerator Class

EventInfos Class

EventsProvider Class

Executable Class

ExecutableEnumerator Class

Executables Class

ExtendedProperties Class

ExtendedProperty Class

ExtendedPropertyEnumerator Class

FlatFileColumn Class

ForEachEnumerator Class

ForEachEnumeratorHost Class

ForEachEnumeratorInfo Class

ForEachEnumeratorInfos Class

ForEachEnumeratorInfosEnumerator Class

ForEachEnumeratorUI Class

ForEachLoop Class

ForEachVariableMapping Class

ForEachVariableMappingEnumerator Class

ForEachVariableMappings Class

ForLoop Class

FtpClientConnection Class

HttpClientConnection Class

IDTSBreakpointSite Interface

IDTSComponentEvents Interface

IDTSComponentPersist Interface

IDTSConfigurationControl Interface

IDTSDowngradableObject Interface

IDTSDumpConfiguration Interface

IDTSEvents Interface

IDTSExecutionMetrics Interface

IDTSExecutionPath Interface

IDTSForEachEnumerator Interface

IDTSForEachEnumeratorUI Interface

IDTSInfoEvents Interface

IDTSLogging Interface

IDTSManagedTask Interface

IDTSName Interface

IDTSObjectHost Interface

IDTSPackageInternal Interface

IDTSPackagePath Interface

IDTSPersist Interface

IDTSPropertiesProvider Interface

IDTSPropertiesProviderEx Interface

IDTSSequence Interface

IDTSSuspend Interface

LogEntryInfo Class

LogEntryInfoEnumerator Class

LogEntryInfos Class

LoggingOptions Class

LogProvider Class

LogProviderBase Class

LogProviderEnumerator Class

LogProviderInfo Class

LogProviderInfoEnumerator Class

LogProviderInfos Class

LogProviders Class

ManagedForEachEnumeratorWrapper Class

ManagedHelper Class

ManagedHelper.ManagedPropertyHelper Class

ManagedWrapper Class

ManagerSerializer Class

NameChecker Class

NameCheckResult Enumeration

ObjectReferenceTracker Class

Package Class

PackageInfo Class

PackageInfoEnumerator Class

PackageInfos Class

PackageItem Class

PackageItems Class

PackageItemState Enumeration

PackageParameterEnumerator Class

PackageUpgradeOptions Class

PackageUpgradeResult Class

Parameter Class

ParameterInfo Class

ParameterInfos Class

Parameters Class

PipelineComponentInfo Class

PipelineComponentInfoEnumerator Class

PipelineComponentInfos Class

PrecedenceConstraint Class

PrecedenceConstraintEnumerator Class

PrecedenceConstraints Class

Project Class

Project.AccessMode Enumeration

ProjectStorageAttributes Enumeration

ProjectVariablesWrapper Class

PropertyEnumerator Class

RunningPackage Class

RunningPackages Class

RunningPackagesEnumerator Class

SelectedLogProviders Class

SsisServerExecution Class

StatusMessage Structure

StorageInfo Class

StorageType Enumeration

Task Class

TaskInfoEnumerator Class

TaskInfos Class

UpgradePackageInfo Class

UpgradeResult Class

UpgradeResultStatus Enumeration

VariableDispenser Class

VariableEnumerator Class

Variables Class

WarningEnumerator Class

Minimize

This topic has not yet been rated - Rate this topic

DTSExecStatus Enumeration

SQL Server 2012

Contains values that indicate the current status of task execution or a container object at the time of the call.

Namespace: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)

public enum DTSExecStatus

	Member name	Description
	Abend	The task experienced an internal error and terminated execution abnormally.
	Completed	Task has completed executing with a success or failed result.
	Executing	Task is currently running.
	None	Task is idle (default value).
	Suspended	Task is currently suspended because the runtime has called suspend because of a breakpoint hit.
	Validating	Task is currently validating.

The following code example shows one way of using the DTSExecStatus enumeration in a package. The method is called to determine the current status of the package at the time of the call.

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

namespace Package_API
{
    class Program
    {
        static void Main(string[] args)
        {
            Package p = new Package();
            p.InteractiveMode = true;
            p.OfflineMode = true;

            // Add a Script Task to the package.
            TaskHost taskH = (TaskHost)p.Executables.Add("STOCK:ScriptTask");
            // Run the package.
            p.Execute();
            // Review the results of the run.
            if (taskH.ExecutionResult == DTSExecResult.Failure || taskH.ExecutionStatus == DTSExecStatus.Abend)
                Console.WriteLine("Task failed or abended");
            else
                Console.WriteLine("Task ran successfully");
        }
    }
}

Sample Output:

Task ran successfully

Reference

Microsoft.SqlServer.Dts.Runtime Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft. All rights reserved.