Microsoft.SqlServer.Dts.Runtime Namespace
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
The Microsoft.SqlServer.Dts.Runtime namespace contains the classes and interfaces to create packages, custom tasks, and other package control flow elements.
Classes
| Name | Description |
|---|---|
| Application |
Discovers and accesses Package objects. It can also access collections and properties that contain information about the system. |
| ApplocalHelper |
ApplocalHelper contains static helper functions that help cope with applocal problems. |
| ApplocalReferenceLoader |
reference loader for app-local assembly |
| BatchUpgradeOptions |
Specifies the options that the Upgrade(IEnumerable<UpgradePackageInfo>, StorageInfo, StorageInfo, BatchUpgradeOptions, IDTSEvents) method will apply to a list of Integration Services packages during the upgrade process. |
| BreakpointManager |
Manages all the breakpoints that are set in on a task. This class cannot be inherited. |
| BreakpointTarget |
Contains information on breakpoints that are set in the package. This class cannot be inherited. |
| BreakpointTargetEnumerator |
Creates a BreakpointTargetEnumerator for the BreakpointTargets collection. This class cannot be inherited. |
| BreakpointTargets |
Contains a collection of BreakpointTarget objects. This class cannot be inherited. |
| Configuration |
Represents a configuration class that contains information about how a package is configured. This class cannot be inherited. |
| ConfigurationEnumerator |
Supports iteration over the Configurations collection. This class cannot be inherited. |
| Configurations |
Represents a collection of Configuration objects. This class cannot be inherited. |
| ConnectionEnumerator |
Supports iteration over the Connections collection. This class cannot be inherited. |
| ConnectionInfo |
Contains information about the connections available on the computer. This class cannot be inherited. |
| ConnectionInfoEnumerator |
Supports iteration over the Connections collection. This class cannot be inherited. |
| ConnectionInfos |
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. |
| ConnectionManager |
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. |
| ConnectionManagerBase |
Represents the abstract base class for connection managers. |
| ConnectionManagerItem |
Represents objects for the connection manager. |
| ConnectionManagerItems |
Represents the connection manager objects. |
| Connections |
Contains a collection of ConnectionManager objects that are accessed through the Package object. This class cannot be inherited. |
| DataTypeInfo |
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. |
| DataTypeInfoEnumerator |
Supports iteration over the DataTypeInfos collection. This class cannot be inherited. |
| DataTypeInfos |
Contains a collection of DataTypeInfo objects. This class cannot be inherited. |
| DBProviderInfo |
Contains information about a database provider. This class cannot be inherited. |
| DBProviderInfoEnumerator |
Supports iteration over the DBProviderInfos collection. This class cannot be inherited. |
| DBProviderInfos |
Contains a collection of DBProviderInfo objects. This class cannot be inherited. |
| DefaultEvents |
Defines the default events that are provided by the Integration Services run-time. |
| DtProjectStorage | |
| DtsComException |
The exception that Integration Services raises when a COM error occurs. |
| DtsComponentException |
The exception that is thrown when an error occurs in a component. |
| DtsConnectionAttribute |
Supplies design time information about a ConnectionManager object. |
| DtsConnectionException |
The exception that is thrown when there is an error in a connection. |
| DtsContainer |
Defines an abstract base class that implements the properties and methods used by all containers and packages. |
| DtsConvert |
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. |
| DtsCouldNotCreateManagedConnectionException |
The exception that specifies that a managed connection could not be created. This class cannot be inherited. |
| DtsCouldNotCreateManagedForEachEnumeratorException |
The exception that specifies that a managed ForEach enumerator could not be created. This class cannot be inherited. |
| DtsEnumerator |
Defines an abstract base class that implements the IEnumerator methods. |
| DtsError |
Contains information about an error that occurred during execution. This class cannot be inherited. |
| DtsErrors |
Represents a collection of DtsError objects. This class cannot be inherited. |
| DtsEventHandler |
A container on a package or other containers that holds executables to run when specific events occur. This class cannot be inherited. |
| DtsEventHandlerEnumerator |
Supports iteration over the DtsEventHandlers collection. This class cannot be inherited. |
| DtsEventHandlers |
Represents a collection of DtsEventHandler objects. This class cannot be inherited. |
| DtsException |
Defines a generic exception class that, depending on the error code returned, creates a class specific to the type of exception that occurred. |
| DtsExponentTooLargeException |
An exception class that is thrown when the X.509 certification key on a package is invalid. |
| DtsForEachEnumeratorAttribute |
Supplies design-time information about a ForEachEnumerator object. This class cannot be inherited. |
| DtsGenericException |
The exception that is thrown when an error occurs and the error is not handled by any other exception class. |
| DtsInvalidBreakpointSiteException |
The exception that is thrown to specify that there is an invalid breakpoint. This class cannot be inherited. |
| DtsInvalidProjectPasswordOrDataException |
Represents the invalid project password or data exception that this class contains during runtime. |
| DtsInvalidProjectUserKeyOrDataException |
Represents the invalid project user key or data exception that this class contains. |
| DtsLogProviderAttribute |
Supplies design time information about a LogProvider object. |
| DTSManagedXmlSerializationHelper |
Represents the helper for the DTS managed XML serialization. |
| DtsNoConnectionAssignedException |
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. |
| DtsNoForEachEnumAssignedException |
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. |
| DtsNoLogProviderAssignedException |
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. |
| DtsNoObjectAssignedException |
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. |
| DtsNotAConnectionException |
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. |
| DtsNotAForEachEnumException |
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. |
| DtsNotALogProviderException |
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. |
| DtsNotAManagedEnumeratorException |
The exception that is thrown to specify that the enumerator is not a managed enumerator. This class cannot be inherited. |
| DtsNoTaskAssignedException |
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. |
| DtsNotATaskException |
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. |
| DtsObject |
Defines an abstract base class that contains the members that are common to all the objects in the Microsoft.SqlServer.Dts.Runtime namespace. |
| DtsPipelineException |
The exception that is thrown when an error occurs in the pipeline. |
| DtsProperties |
Contains a collection of DtsProperty objects. This class cannot be inherited. |
| DtsProperty |
Contains properties and methods used by several containers on their properties. This class cannot be inherited. |
| DtsPropertyAttribute |
Represents the DTS property attribute. |
| DTSReadOnlyCollectionBase |
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. |
| DtsRuntimeException |
The exception that is thrown when there is an error in the control flow. |
| DtsScriptingException |
The exception that is thrown when there is an error in a script task. |
| DtsSqlException |
The exception that is thrown when there is an error in a SQL Task. |
| DtsTaskAttribute |
Supplies design time information about a Task object. |
| DtsTaskException |
The exception that is thrown when an error occurs in a task. |
| DtsToolsException |
The exception that is thrown when an error occurs in one of the tools. |
| DtsWarning |
Contains the properties used when a warning occurs. This class cannot be inherited. |
| DtsWarnings |
Contains a collection of DtsWarning objects. This class cannot be inherited. |
| EmptyEnumerator |
Provides an empty enumerator that is returned by the Integration Services runtime when there are no elements in the collection to enumerate over. |
| EnumReferencedObjects |
Enumerates the referenced objects. |
| ErrorEnumerator |
Supports iteration over the DtsErrors collection. This class cannot be inherited. |
| EventInfo |
Contains information about an event. This class cannot be inherited. |
| EventInfoEnumerator |
Supports iteration over the EventInfos collection. This class cannot be inherited. |
| EventInfos |
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. |
| EventsProvider |
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. |
| Executable |
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. |
| ExecutableEnumerator |
Supports iteration over the Executables collection. This class cannot be inherited. |
| Executables |
Contains a collection of Executable objects. This class cannot be inherited. |
| ExtendedProperties |
Contains a collection of ExtendedProperty objects. This class cannot be inherited. |
| ExtendedProperty |
This class contains members that hold additional information about a package. |
| ExtendedPropertyEnumerator |
Supports iteration over the ExtendedProperties collection. This class cannot be inherited. |
| FlatFileColumn |
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. |
| ForEachEnumerator |
Enumerates over the items that the ForEachLoop is assigned to iterate over. |
| ForEachEnumeratorHost |
Defines the host class for the ForEachEnumerator. This class cannot be inherited. |
| ForEachEnumeratorInfo |
Contains information about the ForEachEnumerator. This class cannot be inherited. |
| ForEachEnumeratorInfos |
A collection of ForEachEnumeratorInfo objects. This class cannot be inherited. |
| ForEachEnumeratorInfosEnumerator |
Supports iteration over the ForEachEnumeratorInfos collection. This class cannot be inherited. |
| ForEachEnumeratorUI |
Provides information for controlling the graphical user interface of the ForEachEnumerator. |
| ForEachLoop |
Provides a container that defines an iterative workflow in a package using the foreach iteration statement. |
| ForEachVariableMapping |
Maps each variable to the value or expression that it holds. This class cannot be inherited. |
| ForEachVariableMappingEnumerator |
Supports iteration over the ForEachVariableMappings collection. This class cannot be inherited. |
| ForEachVariableMappings |
Contains a collection of ForEachVariableMapping objects. This class cannot be inherited. |
| ForLoop |
Provides a container that defines an iterative workflow in a package, using the for iteration statement. |
| FtpClientConnection |
Downloads and uploads data files and manages directories on servers. This class cannot be inherited. |
| HResults |
Copyright (c) 2019 Microsoft Corporation This file contains all the US english event messages and HRESULTs for the SQL Data Transformation Services Runtime, Pipeline, stock tasks, and stock transforms. Message and HRESULT naming convention Error HRESULTs - Begin with DTS_E_ End with the description of the failed operation Warning HRESULTs - Begin with DTS_W_ End with the description of the warning operation Information HRESULTs - Begin with DTS_I_ End with the description of the operation Success HRESULTs - Begin with DTS_S_ End with the description of the successful operation Messages for the event log - Begin with DTS_MSG_ End with the description of the message Values are 32 bit values laid out as follows: 3 3 2 2 2 2 2 2 2 2 2 2 1 1 1 1 1 1 1 1 1 1 1 0 9 8 7 6 5 4 3 2 1 0 9 8 7 6 5 4 3 2 1 0 9 8 7 6 5 4 3 2 1 0 +---+-+-+-----------------------+-------------------------------+ |Sev|C|R| Facility | Code | +---+-+-+-----------------------+-------------------------------+ where Sev - is the severity code 00 - Success 01 - Informational 10 - Warning 11 - Error C - is the Customer code flag R - is a reserved bit Facility - is the facility code Code - is the facility's status code |
| HttpClientConnection |
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. |
| LogEntryInfo |
Contains properties that describe a log entry. This class cannot be inherited. |
| LogEntryInfoEnumerator |
Supports iteration over the LogEntryInfos collection. This class cannot be inherited. |
| LogEntryInfos |
Contains a collection of LogEntryInfo objects. This class cannot be inherited. |
| LoggingOptions |
Contains members that regulate what information is included or excluded from logging. This class cannot be inherited. |
| LogProvider |
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. |
| LogProviderBase |
Defines the abstract base class for managed log providers. |