Microsoft.SqlServer.Dts.Runtime Namespace

 

The Microsoft.SqlServer.Dts.Runtime namespace contains the classes and interfaces to create packages, custom tasks, and other package control flow elements.

ClassDescription
System_CAPS_pubclassApplication

Discovers and accesses Package objects. It can also access collections and properties that contain information about the system.

System_CAPS_pubclassBatchUpgradeOptions

Specifies the options that the Upgrade method will apply to a list of Integration Services packages during the upgrade process.

System_CAPS_pubclassBreakpointManager

Manages all the breakpoints that are set in on a task. This class cannot be inherited.

System_CAPS_pubclassBreakpointTarget

Contains information on breakpoints that are set in the package. This class cannot be inherited.

System_CAPS_pubclassBreakpointTargetEnumerator

Creates a BreakpointTargetEnumerator for the BreakpointTargets collection. This class cannot be inherited.

System_CAPS_pubclassBreakpointTargets

Contains a collection of BreakpointTarget objects. This class cannot be inherited.

System_CAPS_pubclassConfiguration

Represents a configuration class that contains information about how a package is configured. This class cannot be inherited.

System_CAPS_pubclassConfigurationEnumerator

Supports iteration over the Configurations collection. This class cannot be inherited.

System_CAPS_pubclassConfigurations

Represents a collection of Configuration objects. This class cannot be inherited.

System_CAPS_pubclassConnectionEnumerator

Supports iteration over the Connections collection. This class cannot be inherited.

System_CAPS_pubclassConnectionInfo

Contains information about the connections available on the computer. This class cannot be inherited.

System_CAPS_pubclassConnectionInfoEnumerator

Supports iteration over the Connections collection. This class cannot be inherited.

System_CAPS_pubclassConnectionInfos

Contains information about all the connections on the computer. The collection contains ConnectionInfo objects that provide the details about each connection. The collection is available using the Application class. This class cannot be inherited.

System_CAPS_pubclassConnectionManager

Provides the information that you must have to connect to a data source. All classes that inherit from the ConnectionManager contain the same properties and methods. The ConnectionManager class isolates the implementation details of the different connection types from the runtime. This enables the runtime to interact with each connection manager in a consistent and predictable manner. Connection managers contain a set of stock properties that all connections have in common, such as the Name, ID, Description, and ConnectionString. However, each connection type has additional properties that are specific to that connection type. These can be accessed through the Properties collection.This class cannot be inherited.

System_CAPS_pubclassConnectionManagerBase

Represents the abstract base class for connection managers.

System_CAPS_pubclassConnectionManagerItem

Represents objects for the connection manager.

System_CAPS_pubclassConnectionManagerItems

Represents the connection manager objects.

System_CAPS_pubclassConnections

Contains a collection of ConnectionManager objects that are accessed through the Package object. This class cannot be inherited.

System_CAPS_pubclassDataTypeInfo

Contains members that return information regarding the data type of any SQL Server Integration Services (SSIS) object for an Application. This class cannot be inherited.

System_CAPS_pubclassDataTypeInfoEnumerator

Supports iteration over the DataTypeInfos collection. This class cannot be inherited.

System_CAPS_pubclassDataTypeInfos

Contains a collection of DataTypeInfo objects. This class cannot be inherited.

System_CAPS_pubclassDBProviderInfo

Contains information about a database provider. This class cannot be inherited.

System_CAPS_pubclassDBProviderInfoEnumerator

Supports iteration over the DBProviderInfos collection. This class cannot be inherited.

System_CAPS_pubclassDBProviderInfos

Contains a collection of DBProviderInfo objects. This class cannot be inherited.

System_CAPS_pubclassDefaultEvents

Defines the default events that are provided by the Integration Services run-time.

System_CAPS_pubclassDtProjectStorage

System_CAPS_pubclassDtsComException

The exception that Integration Services raises when a COM error occurs.

System_CAPS_pubclassDtsComponentException

The exception that is thrown when an error occurs in a component.

System_CAPS_pubclassDtsConnectionAttribute

Supplies design time information about a ConnectionManager object.

System_CAPS_pubclassDtsConnectionException

The exception that is thrown when there is an error in a connection.

System_CAPS_pubclassDtsContainer

Defines an abstract base class that implements the properties and methods used by all containers and packages.

System_CAPS_pubclassDtsConvert

Provides conversion methods to convert managed Integation Services run-time objects to their native implementations and from native to managed implementations. This class cannot be inherited.

System_CAPS_pubclassDtsCouldNotCreateManagedConnectionException

The exception that specifies that a managed connection could not be created. This class cannot be inherited.

System_CAPS_pubclassDtsCouldNotCreateManagedForEachEnumeratorException

The exception that specifies that a managed ForEach enumerator could not be created. This class cannot be inherited.

System_CAPS_pubclassDtsEnumerator

Defines an abstract base class that implements the IEnumerator methods.

System_CAPS_pubclassDtsError

Contains information about an error that occurred during execution. This class cannot be inherited.

System_CAPS_pubclassDtsErrors

Represents a collection of DtsError objects. This class cannot be inherited.

System_CAPS_pubclassDtsEventHandler

A container on a package or other containers that holds executables to run when specific events occur. This class cannot be inherited.

System_CAPS_pubclassDtsEventHandlerEnumerator

Supports iteration over the DtsEventHandlers collection. This class cannot be inherited.

System_CAPS_pubclassDtsEventHandlers

Represents a collection of DtsEventHandler objects. This class cannot be inherited.

System_CAPS_pubclassDtsException

Defines a generic exception class that, depending on the error code returned, creates a class specific to the type of exception that occurred.

System_CAPS_pubclassDtsExponentTooLargeException

An exception class that is thrown when the X.509 certification key on a package is invalid.

System_CAPS_pubclassDtsForEachEnumeratorAttribute

Supplies design-time information about a ForEachEnumerator object. This class cannot be inherited.

System_CAPS_pubclassDtsGenericException

The exception that is thrown when an error occurs and the error is not handled by any other exception class.

System_CAPS_pubclassDtsInvalidBreakpointSiteException

The exception that is thrown to specify that there is an invalid breakpoint. This class cannot be inherited.

System_CAPS_pubclassDtsInvalidProjectPasswordOrDataException

Represents the invalid project password or data exception that this class contains during runtime.

System_CAPS_pubclassDtsInvalidProjectUserKeyOrDataException

Represents the invalid project user key or data exception that this class contains.

System_CAPS_pubclassDtsLogProviderAttribute

Supplies design time information about a LogProvider object.

System_CAPS_pubclassDTSManagedXmlSerializationHelper

Represents the helper for the DTS managed XML serialization.

System_CAPS_pubclassDtsNoConnectionAssignedException

The exception that is thrown to specify that an internal error occurred when a managed wrapper is used for a native object that is not of the correct type.

System_CAPS_pubclassDtsNoForEachEnumAssignedException

The exception that is thrown to specify that an internal error occurred when a managed wrapper is used for a native object that is not of the type ForEachEnumerator.

System_CAPS_pubclassDtsNoLogProviderAssignedException

The exception that is thrown to specify that an internal error occurred when a managed wrapper is used for a native object that is not of the type LogProvider.

System_CAPS_pubclassDtsNoObjectAssignedException

The exception that is thrown to specify that an internal error occurred when a managed wrapper is used for a native object that is not of the correct type.

System_CAPS_pubclassDtsNotAConnectionException

The exception that is thrown to specify that an internal error occurred when a managed wrapper is used for a native object that is not of the correct type.

System_CAPS_pubclassDtsNotAForEachEnumException

The exception that is thrown to specify that an internal error occurred when a managed wrapper is used for a native object that is not of the type ForEachEnumerator.

System_CAPS_pubclassDtsNotALogProviderException

The exception that is thrown to specify that an internal error occurred when a managed wrapper is used for a native object that is not of the type LogProvider.

System_CAPS_pubclassDtsNotAManagedEnumeratorException

The exception that is thrown to specify that the enumerator is not a managed enumerator. This class cannot be inherited.

System_CAPS_pubclassDtsNoTaskAssignedException

The exception that is thrown to specify that an internal error occurred when a managed wrapper is used for a native object that is not of the correct type.

System_CAPS_pubclassDtsNotATaskException

The exception that is thrown to specify that an internal error occurred when a managed wrapper is used for a native object that is not of the correct type.

System_CAPS_pubclassDtsObject

Defines an abstract base class that contains the members that are common to all the objects in the Microsoft.SqlServer.Dts.Runtime namespace.

System_CAPS_pubclassDtsPipelineException

The exception that is thrown when an error occurs in the pipeline.

System_CAPS_pubclassDtsProperties

Contains a collection of DtsProperty objects. This class cannot be inherited.

System_CAPS_pubclassDtsProperty

Contains properties and methods used by several containers on their properties. This class cannot be inherited.

System_CAPS_pubclassDtsPropertyAttribute

This API supports the product infrastructure and is not intended to be used directly from your code. Represents the DTS property attribute.

System_CAPS_pubclassDTSReadOnlyCollectionBase

Defines an abstract base class that implements the common members used by all Integration Services read-only collections. It provides the abstract (MustInherit in Visual Basic) base class for a strongly typed collection.

System_CAPS_pubclassDtsRuntimeException

The exception that is thrown when there is an error in the control flow.

System_CAPS_pubclassDtsScriptingException

The exception that is thrown when there is an error in a script task.

System_CAPS_pubclassDtsSqlException

The exception that is thrown when there is an error in a SQL Task.

System_CAPS_pubclassDtsTaskAttribute

Supplies design time information about a Task object.

System_CAPS_pubclassDtsTaskException

The exception that is thrown when an error occurs in a task.

System_CAPS_pubclassDtsToolsException

The exception that is thrown when an error occurs in one of the tools.

System_CAPS_pubclassDtsWarning

Contains the properties used when a warning occurs. This class cannot be inherited.

System_CAPS_pubclassDtsWarnings

Contains a collection of DtsWarning objects. This class cannot be inherited.

System_CAPS_pubclassEmptyEnumerator

Provides an empty enumerator that is returned by the Integration Services runtime when there are no elements in the collection to enumerate over.

System_CAPS_pubclassEnumReferencedObjects

This API supports the product infrastructure and is not intended to be used directly from your code. Enumerates the referenced objects.

System_CAPS_pubclassErrorEnumerator

Supports iteration over the DtsErrors collection. This class cannot be inherited.

System_CAPS_pubclassEventInfo

Contains information about an event. This class cannot be inherited.

System_CAPS_pubclassEventInfoEnumerator

Supports iteration over the EventInfos collection. This class cannot be inherited.

System_CAPS_pubclassEventInfos

Contains a collection of EventInfo objects. The run-time engine exposes an EventInfos collection on all containers in the package hierarchy. The collection that a task receives is a reference to EventInfos collection on the TaskHost that is wrapping the task. Other containers' EventInfos collections contain aggregated contents of their children’s EventInfos collections. This class cannot be inherited.

System_CAPS_pubclassEventsProvider

Defines an abstract class that contains a collection of event handler containers and the EventInfos collection. This class routes events to those event handlers when an event is received.

System_CAPS_pubclassExecutable

Defines an abstract class that provides the methods that all objects that are run by the run-time engine are required to inherit and implement.

System_CAPS_pubclassExecutableEnumerator

Supports iteration over the Executables collection. This class cannot be inherited.

System_CAPS_pubclassExecutables

Contains a collection of Executable objects. This class cannot be inherited.

System_CAPS_pubclassExtendedProperties

Contains a collection of ExtendedProperty objects. This class cannot be inherited.

System_CAPS_pubclassExtendedProperty

This class contains members that hold additional information about a package.

System_CAPS_pubclassExtendedPropertyEnumerator

Supports iteration over the ExtendedProperties collection. This class cannot be inherited.

System_CAPS_pubclassFlatFileColumn

Contains information that defines the properties of columns in a flat file source or destination data adapter. The flat file adapter is used for accessing data in flat files. This class cannot be inherited.

System_CAPS_pubclassForEachEnumerator

Enumerates over the items that the ForEachLoop is assigned to iterate over.

System_CAPS_pubclassForEachEnumeratorHost

Defines the host class for the ForEachEnumerator. This class cannot be inherited.

System_CAPS_pubclassForEachEnumeratorInfo

Contains information about the ForEachEnumerator. This class cannot be inherited.

System_CAPS_pubclassForEachEnumeratorInfos

A collection of ForEachEnumeratorInfo objects. This class cannot be inherited.

System_CAPS_pubclassForEachEnumeratorInfosEnumerator

Supports iteration over the ForEachEnumeratorInfos collection. This class cannot be inherited.

System_CAPS_pubclassForEachEnumeratorUI

Provides information for controlling the graphical user interface of the ForEachEnumerator.

System_CAPS_pubclassForEachLoop

Provides a container that defines an iterative workflow in a package using the foreach iteration statement.

System_CAPS_pubclassForEachVariableMapping

Maps each variable to the value or expression that it holds. This class cannot be inherited.

System_CAPS_pubclassForEachVariableMappingEnumerator

Supports iteration over the ForEachVariableMappings collection. This class cannot be inherited.

System_CAPS_pubclassForEachVariableMappings

Contains a collection of ForEachVariableMapping objects. This class cannot be inherited.

System_CAPS_pubclassForLoop

Provides a container that defines an iterative workflow in a package, using the for iteration statement.

System_CAPS_pubclassFtpClientConnection

Downloads and uploads data files and manages directories on servers. This class cannot be inherited.

System_CAPS_pubclassHResults

Contains all event messages and HRESULTs for the Integration Services runtime, pipeline, stock tasks, and stock transforms.

System_CAPS_pubclassHttpClientConnection

Contains properties and methods that enable a package to access a Web server using the HTTP protocol to send or receive files. This class cannot be inherited.

System_CAPS_pubclassLogEntryInfo

Contains properties that describe a log entry. This class cannot be inherited.

System_CAPS_pubclassLogEntryInfoEnumerator

Supports iteration over the LogEntryInfos collection. This class cannot be inherited.

System_CAPS_pubclassLogEntryInfos

Contains a collection of LogEntryInfo objects. This class cannot be inherited.

System_CAPS_pubclassLoggingOptions

Contains members that regulate what information is included or excluded from logging. This class cannot be inherited.

System_CAPS_pubclassLogProvider

Contains information about a log provider associated with a package. All log providers associated with a package are located in the LogProviders collection. For log providers on the computer, use the Application class and view the LogProviderInfos collection. This class cannot be inherited.

System_CAPS_pubclassLogProviderBase

Defines the abstract base class for managed log providers.

System_CAPS_pubclassLogProviderEnumerator

Supports iteration over the LogProviders collection. This class cannot be inherited.

System_CAPS_pubclassLogProviderInfo

Provides information about the log providers found on the computer. This class cannot be inherited.

System_CAPS_pubclassLogProviderInfoEnumerator

Supports a simple iteration over the LogProviderInfos collection. This class cannot be inherited.

System_CAPS_pubclassLogProviderInfos

Contains a collection of LogProviderInfo objects. This class cannot be inherited.

System_CAPS_pubclassLogProviders

Contains a collection of LogProvider objects associated with the package. This class cannot be inherited.

System_CAPS_pubclassManagedForEachEnumeratorWrapper

This API supports the product infrastructure and is not intended to be used directly from your code. Represents the wrapper for the managed For Each enumerator. This class cannot be inherited.

System_CAPS_pubclassManagedHelper

This API supports the product infrastructure and is not intended to be used directly from your code. Represents the managed helper.

System_CAPS_pubclassManagedHelper.ManagedPropertyHelper

This API supports the product infrastructure and is not intended to be used directly from your code. Represents the managed property header.

System_CAPS_pubclassManagedWrapper

This API supports the product infrastructure and is not intended to be used directly from your code. Represents the managed wrapper.

System_CAPS_pubclassManagerSerializer

This API supports the product infrastructure and is not intended to be used directly from your code. Represents the manager serializer.

System_CAPS_pubclassNameChecker

Represents the name checker.

System_CAPS_pubclassObjectReferenceTracker

Provides analysis regarding the impact and consequences of deleting variables and connections from a package. This class cannot be inherited.

System_CAPS_pubclassPackage

Represents the package container. This class cannot be inherited.

System_CAPS_pubclassPackageInfo

Contains properties that return all the information relating to a package, such as the date it was created, version numbers, and package size. This class cannot be inherited.

System_CAPS_pubclassPackageInfoEnumerator

Supports iteration over the PackageInfos collection. This class cannot be inherited.

System_CAPS_pubclassPackageInfos

Contains a collection of packages found in Microsoft SQL Server or the Integration Services service. This class cannot be inherited.

System_CAPS_pubclassPackageItem

Contains package related information including the package and state.

System_CAPS_pubclassPackageItems

Contains a collection of PackageItem objects.

System_CAPS_pubclassPackageParameterEnumerator

Represents the package parameter enumerator.

System_CAPS_pubclassPackageUpgradeOptions

Specifies the options to be applied when an Integration Services package is upgraded.

System_CAPS_pubclassPackageUpgradeResult

Specifies the upgrade results for a package.

System_CAPS_pubclassParameter

Represents an abstract base class used by both package parameter and project parameter.

System_CAPS_pubclassParameterInfo

Represents a read only copy of the parameter information so that applications can get parameter information without having to load the whole package object.

System_CAPS_pubclassParameterInfos

Represents a collection of parameter objects.

System_CAPS_pubclassParameters

Represents a class used by both the package parameters and project parameters collection.

System_CAPS_pubclassPipelineComponentInfo

Contains properties that describe a pipeline component that is currently installed on the local computer and are ready to be used in a pipeline.

System_CAPS_pubclassPipelineComponentInfoEnumerator

Supports iteration over the PipelineComponentInfos collection. This class cannot be inherited.

System_CAPS_pubclassPipelineComponentInfos

Contains a collection of PipelineComponentInfo objects. This class cannot be inherited.

System_CAPS_pubclassPrecedenceConstraint

Specifies the properties for configuring a precedence constraint between two containers. This class cannot be inherited.

System_CAPS_pubclassPrecedenceConstraintEnumerator

Supports a simple iteration over the PrecedenceConstraints collection. This class cannot be inherited.

System_CAPS_pubclassPrecedenceConstraints

Contains a collection of PrecedenceConstraint objects. This class cannot be inherited.

System_CAPS_pubclassProject

Represents Integration Services project which contains packages and parameters.

System_CAPS_pubclassProjectVariablesWrapper

Contains a collection of project variables wrapper.

System_CAPS_pubclassPropertyEnumerator

Supports iteration over the DtsProperties collection. This class cannot be inherited.

System_CAPS_pubclassReferenceLoader

System_CAPS_pubclassRunningPackage

Provides a reference to the run-time package to use from the Integration Services service. This class cannot be inherited.

System_CAPS_pubclassRunningPackages

Contains a collection of RunningPackage objects. This collection contains the list of packages that were running when the GetRunningPackages method was called, and is not updated when a new package starts or a listed package terminates. If you need a new snapshot, you should call GetRunningPackages again. This class cannot be inherited.

System_CAPS_pubclassRunningPackagesEnumerator

Supports iteration over the RunningPackages collection. This class cannot be inherited.

System_CAPS_pubclassSelectedLogProviders

Contains a collection of selected LogProvider objects. This class cannot be inherited.

System_CAPS_pubclassSensitiveConnectionManagerBase

System_CAPS_pubclassSensitiveStringAttribute

System_CAPS_pubclassSequence

Defines a control flow that is a subset of the package control flow. Use Sequence containers to group the package into multiple separate control flows that each contain one or more tasks and containers that run within the overall package control flow. This class cannot be inherited.

System_CAPS_pubclassSsisServerExecution

Represents the SSIS server execution.

System_CAPS_pubclassStorageInfo

Provides information about the storage location for either the original or the upgraded Integration Services packages.

System_CAPS_pubclassTask

Defines an abstract class that implements the methods and properties common to all tasks in Integration Services. 

System_CAPS_pubclassTaskHost

Provides a container that encapsulates a single task. In the SSIS Designer, the TaskHost is not configured separately; instead, it is configured when you set the properties of the task it encapsulates.

System_CAPS_pubclassTaskInfo

Contains information about a task installed on the local computer.

System_CAPS_pubclassTaskInfoEnumerator

Supports iteration over the TaskInfo collection. This class cannot be inherited.

System_CAPS_pubclassTaskInfos

Contains a collection of TaskInfo objects. This class cannot be inherited.

System_CAPS_pubclassUpgradePackageInfo

Stores information about an Integration Services package that is to be upgraded.

System_CAPS_pubclassUpgradeResult

Determines the result of upgrading a collection of Integration Services packages.

System_CAPS_pubclassVariable

Represents a variable on a package, task, or container. This class cannot be inherited.

System_CAPS_pubclassVariableDispenser

Accesses the Variables collection during package execution. This class cannot be inherited.

System_CAPS_pubclassVariableEnumerator

Supports iteration over the Variables collection. This class cannot be inherited.

System_CAPS_pubclassVariables

Contains a collection of Variables objects, which are accessed through several objects. This class cannot be inherited.

System_CAPS_pubclassWarningEnumerator

Supports iteration over the DtsWarnings collection. This class cannot be inherited.

StructureDescription
System_CAPS_pubstructureDTSEventColumnFilter

Contains a field for every column that you can put into a log entry. To select columns for writing into the log, set the field's value to true. Set the value to false for every field you do not want added to the log entry.

System_CAPS_pubstructureStatusMessage

Specifies the warning and error messages that result from upgrading an Integration Services package.

InterfaceDescription
System_CAPS_pubinterfaceIDTSBreakpointSite

Defines the interaction between the Integration Services run-time engine and the task for exposing breakpoints and for creating and managing custom breakpoints.

System_CAPS_pubinterfaceIDTSComponentEvents

Defines an interface that provides event firing.

System_CAPS_pubinterfaceIDTSComponentPersist

Allows properties and settings for components and tasks to be saved and loaded from the package XML.

System_CAPS_pubinterfaceIDTSConfigurationControl

Provides a property that controls how a package loads configurations.

System_CAPS_pubinterfaceIDTSDowngradableObject

This API supports the product infrastructure and is not intended to be used directly from your code. Represents the interface for the DTS downgradable object.

System_CAPS_pubinterfaceIDTSDumpConfiguration

Represents the configuration for the dumping of Data Transformation Service interface.

System_CAPS_pubinterfaceIDTSEvents

Defines a set of events used by the TaskHost on behalf of a task.

System_CAPS_pubinterfaceIDTSExecutionMetrics

Defines the metrics used to track the execution of a container.

System_CAPS_pubinterfaceIDTSExecutionPath

Represents the DTS execution path.

System_CAPS_pubinterfaceIDTSForEachEnumerator

Provides the methods and properties for the ForEachEnumerator.

System_CAPS_pubinterfaceIDTSForEachEnumeratorUI

Contains the members implemented by the ForEachEnumeratorUI user interface class.

System_CAPS_pubinterfaceIDTSInfoEvents

Defines an interface that is used to fire informational, warning, and error events.

System_CAPS_pubinterfaceIDTSLogging

Defines the logging options for a container.

System_CAPS_pubinterfaceIDTSManagedTask

Defines an interface implemented on task classes to identify the class as a managed task.

System_CAPS_pubinterfaceIDTSName

Defines properties commonly used by many objects in the Integration Services runtime. The common properties of named objects include a name, a creation name, an ID (GUID), and a description.

System_CAPS_pubinterfaceIDTSObjectHost

Defines an interface that allows components to be treated as generic host objects.

System_CAPS_pubinterfaceIDTSPackageInternal

This API supports the product infrastructure and is not intended to be used directly from your code. Defines an interface implemented by containers that need to have the internal property.

System_CAPS_pubinterfaceIDTSPackagePath

Defines an interface implemented by containers that need to have the package path returned into a property.

System_CAPS_pubinterfaceIDTSPersist

Defines an interface that enables saving and loading data.

System_CAPS_pubinterfaceIDTSPropertiesProvider

Defines an interface, inherited by containers, that enables properties to be set by an expression, and allows an enumerable collection of properties to be associated with the container.

System_CAPS_pubinterfaceIDTSPropertiesProviderEx

Represents the DTS properties provider expressions.

System_CAPS_pubinterfaceIDTSSequence

Contains two collections used by containers.

System_CAPS_pubinterfaceIDTSSuspend

Provides methods and properties that are called by the run-time engine to notify tasks to suspend execution.

EnumerationDescription
System_CAPS_pubenumProject.AccessMode

Defines the constants for read-only or read/write access to a project.

System_CAPS_pubenumActionOnExistType

Defines the behavior that occurs when an upgrade package has the same name as an existing Integration Services package.

System_CAPS_pubenumConnectionManagerItemState

Specifies the state of the connection manager item.

System_CAPS_pubenumDTSBreakpointHitTest

Enumerates the values for the hit count types. This class works with the BreakpointTarget class.

System_CAPS_pubenumDTSCheckpointUsage

Specifies values that describe if, or when, a package is restarted.

System_CAPS_pubenumDTSConfigurationType

Specifies the ways that a configuration for a package can be saved.

System_CAPS_pubenumDTSConnectionManagerScope

Specifies the DTS connection manager scope.

System_CAPS_pubenumDTSEventFilterKind

Describes the kind of event filter that is set on logging.

System_CAPS_pubenumDTSExecResult

Provides values that describe the result of a task execution.

System_CAPS_pubenumDTSExecStatus

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

System_CAPS_pubenumDTSExecutionLocation

This API supports the product infrastructure and is not intended to be used directly from your code. Specifies the DTS execution location.

System_CAPS_pubenumDTSFileConnectionUsageType

Provides information about how a connection is used by a component client.

System_CAPS_pubenumDTSForcedExecResult

Specifies the execution result of a container when the container's ForceExecutionValue is set to true.

System_CAPS_pubenumDTSLogEntryFrequency

Provides information to assist in log planning. You pick the hint that most closely corresponds to the frequency that you expect to generate a particular log entry in your task. This enumeration property then assists users of the package when they want to set up filtering of log entries. The user can view the property, and know in advance if there will be an overwhelming number of entries of a particular type, and plan accordingly.

System_CAPS_pubenumDTSLoggingMode

Specifies the logging behavior of the container. The container can turn on logging, disable logging, or specify that the setting to use is the setting found on the parent container.

System_CAPS_pubenumDTSObjectHostType

Describes the type of container that is hosting the other task or container.

System_CAPS_pubenumDTSObjectReferenceType

Specifies the types of objects that the ObjectReferenceTracker class will provide impact analysis for. This enumeration is used by the EnumReferencedObjects class, which in turn is used by the Package class in its FindReferencedObjects method.

System_CAPS_pubenumDTSPackageInfoFlags

Describes whether a package is a folder or package. It is used for setting a valid value in the Flags property.

System_CAPS_pubenumDTSPackageType

Identifies the tool that created the package.

System_CAPS_pubenumDTSPipelineComponentType

Classifies pipeline components by category.

System_CAPS_pubenumDTSPrecedenceEvalOp

Indicates the evaluation operations that the precedence constraint uses.

System_CAPS_pubenumDTSPriorityClass

Describes the priority of a thread in a class.

System_CAPS_pubenumDTSProductLevel

Specifies the SQL Server product edition. 

System_CAPS_pubenumDTSPropertyKind

Contains values that describe the type of property.

System_CAPS_pubenumDTSProtectionLevel

Controls the handling of sensitive information in the package.

System_CAPS_pubenumDTSProviderSubType

Identifies a specific OLE DB provider. The enumeration value also identifies the data type format used by that provider when the ProviderType is OLE DB.

System_CAPS_pubenumDTSProviderType

Describes the kind of provider that is stored.

System_CAPS_pubenumDTSServerParameterType

Specifies the DTS server parameter type.

System_CAPS_pubenumDTSSignatureStatus

Describes the status of the digital signature.

System_CAPS_pubenumDTSTargetServerVersion

System_CAPS_pubenumDTSTransactionOption

Describes transaction supportability and specifies whether a container participates in transactions.

System_CAPS_pubenumNameCheckResult

Specifies the result of a name check.

System_CAPS_pubenumPackageFormatVersionUpdate

System_CAPS_pubenumPackageItemState

Specifies the state of a package item.

System_CAPS_pubenumProjectStorageAttributes

Specifies the attributes of project storage.

System_CAPS_pubenumStorageType

Defines the type of storage to which upgraded Integration Services packages will be saved.

System_CAPS_pubenumUpgradeResultStatus

Defines the results of upgrading an Integration Services package.

Return to top
Show: