Export (0) Print
Expand All
Expand Minimize
2 out of 12 rated this helpful - Rate this topic

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
ApplicationDiscovers and accesses Package objects. It can also access collections and properties that contain information about the system.
BreakpointManagerManages all the breakpoints that are set in on a task. This class cannot be inherited.
BreakpointTargetContains information on breakpoints that are set in the package. This class cannot be inherited.
BreakpointTargetEnumeratorCreates a BreakpointTargetEnumerator for the BreakpointTargets collection. This class cannot be inherited.
BreakpointTargetsContains a collection of BreakpointTarget objects. This class cannot be inherited.
ConfigurationRepresents a configuration class that contains information about how a package is configured. This class cannot be inherited.
ConfigurationEnumeratorSupports iteration over the Configurations collection. This class cannot be inherited.
ConfigurationsRepresents a collection of Configuration objects. This class cannot be inherited.
ConnectionEnumeratorSupports iteration over the Connections collection. This class cannot be inherited.
ConnectionInfoContains information about the connections available on the computer. This class cannot be inherited.
ConnectionInfoEnumeratorSupports iteration over the Connections collection. This class cannot be inherited.
ConnectionInfosContains 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.
ConnectionManagerProvides 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.
ConnectionManagerBaseRepresents the abstract base class for connection managers.
ConnectionsContains a collection of ConnectionManager objects that are accessed through the Package object. This class cannot be inherited.
DataTypeInfoContains members that return information regarding the data type of any SQL Server Integration Services (SSIS) object for an Application. This class cannot be inherited.
DataTypeInfoEnumeratorSupports iteration over the DataTypeInfos collection. This class cannot be inherited.
DataTypeInfosContains a collection of DataTypeInfo objects. This class cannot be inherited.
DBProviderInfoContains information about a database provider. This class cannot be inherited.
DBProviderInfoEnumeratorSupports iteration over the DBProviderInfos collection. This class cannot be inherited.
DBProviderInfosContains a collection of DBProviderInfo objects. This class cannot be inherited.
DefaultEventsDefines the default events that are provided by the Integration Services run-time.
DtsComponentExceptionThe exception that is thrown when an error occurs in a component.
DtsConnectionAttributeSupplies design time information about a ConnectionManager object.
DtsConnectionExceptionThe exception that is thrown when there is an error in a connection.
DtsContainerDefines an abstract base class that implements the properties and methods used by all containers and packages.
DtsConvertProvides 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. This class is not CLS-compliant.
DtsCouldNotCreateManagedConnectionExceptionThe exception that specifies that a managed connection could not be created. This class cannot be inherited.
DtsCouldNotCreateManagedForEachEnumeratorExceptionThe exception that specifies that a managed ForEach enumerator could not be created. This class cannot be inherited.
DtsEnumeratorDefines an abstract base class that implements the IEnumerator methods.
DtsErrorContains information about an error that occurred during execution. This class cannot be inherited.
DtsErrorsRepresents a collection of DtsError objects. This class cannot be inherited.
DtsEventHandlerA container on a package or other containers that holds executables to run when specific events occur. This class cannot be inherited.
DtsEventHandlerEnumeratorSupports iteration over the DtsEventHandlers collection. This class cannot be inherited.
DtsEventHandlersA collection of DtsEventHandler objects. This class cannot be inherited.
DtsExceptionDefines a generic exception class that, depending on the error code returned, creates a class specific to the type of exception that occurred.
DtsExponentTooLargeExceptionAn exception class that is thrown when the X.509 certification key on a package is invalid.
DtsForEachEnumeratorAttributeSupplies design-time information about a ForEachEnumerator object. This class cannot be inherited.
DtsGenericExceptionThe exception that is thrown when an error occurs and the error is not handled by any other exception class.
DtsInvalidBreakpointSiteExceptionThe exception that is thrown to specify that there is an invalid breakpoint. This class cannot be inherited.
DtsLogProviderAttributeSupplies design time information about a LogProvider object.
DtsNoConnectionAssignedExceptionThe 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.
DtsNoForEachEnumAssignedExceptionThe 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.
DtsNoLogProviderAssignedExceptionThe 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.
DtsNoObjectAssignedExceptionThe 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.
DtsNotAConnectionExceptionThe 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.
DtsNotAForEachEnumExceptionThe 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.
DtsNotALogProviderExceptionThe 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.
DtsNotAManagedEnumeratorExceptionThe exception that is thrown to specify that the enumerator is not a managed enumerator. This class cannot be inherited.
DtsNoTaskAssignedExceptionThe 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.
DtsNotATaskExceptionThe 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.
DtsObjectDefines an abstract base class that contains the members that are common to all the objects in the Microsoft.SqlServer.Dts.Runtime namespace.
DtsPipelineExceptionThe exception that is thrown when an error occurs in the pipeline.
DtsPropertiesContains a collection of DtsProperty objects. This class cannot be inherited.
DtsPropertyContains properties and methods used by several containers on their properties. This class cannot be inherited.
DtsPropertyAttribute 
DTSReadOnlyCollectionBaseDefines 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.
DtsRuntimeExceptionThe exception that is thrown when there is an error in the control flow.
DtsScriptingExceptionThe exception that is thrown when there is an error in a script task.
DtsSqlExceptionThe exception that is thrown when there is an error in a SQL Task.
DtsTaskAttributeSupplies design time information about a Task object.
DtsTaskExceptionThe exception that is thrown when an error occurs in a task.
DtsToolsExceptionThe exception that is thrown when an error occurs in one of the tools.
DtsWarningContains the properties used when a warning occurs. This class cannot be inherited.
DtsWarningsContains a collection of DtsWarning objects. This class cannot be inherited.
EmptyEnumeratorProvides an empty enumerator that is returned by the Integration Services runtime when there are no elements in the collection to enumerate over.
EnumReferencedObjects 
ErrorEnumeratorSupports iteration over the DtsErrors collection. This class cannot be inherited.
EventInfoContains information about an event. This class cannot be inherited.
EventInfoEnumeratorSupports iteration over the EventInfos collection. This class cannot be inherited.
EventInfosContains 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.
EventsProviderDefines 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.
ExecutableDefines an abstract class that provides the methods that all objects that are run by the run-time engine are required to inherit and implement.
ExecutableEnumeratorSupports iteration over the Executables collection. This class cannot be inherited.
ExecutablesContains a collection of Executable objects. This class cannot be inherited.
ExtendedPropertiesContains a collection of ExtendedProperty objects. This class cannot be inherited.
ExtendedPropertyThis class contains members that hold additional information about a package.
ExtendedPropertyEnumeratorSupports iteration over the ExtendedProperties collection. This class cannot be inherited.
FlatFileColumnContains 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.
ForEachEnumeratorEnumerates over the items that the ForEachLoop is assigned to iterate over.
ForEachEnumeratorHostDefines the host class for the ForEachEnumerator. This class cannot be inherited.
ForEachEnumeratorInfoContains information about the ForEachEnumerator. This class cannot be inherited.
ForEachEnumeratorInfosA collection of ForEachEnumeratorInfo objects. This class cannot be inherited.
ForEachEnumeratorInfosEnumeratorSupports iteration over the ForEachEnumeratorInfos collection. This class cannot be inherited.
ForEachEnumeratorUIProvides information for controlling the graphical user interface of the ForEachEnumerator.
ForEachLoopProvides a container that defines an iterative workflow in a package using the foreach iteration statement.
ForEachVariableMappingMaps each variable to the value or expression that it holds. This class cannot be inherited.
ForEachVariableMappingEnumeratorSupports iteration over the ForEachVariableMappings collection. This class cannot be inherited.
ForEachVariableMappingsContains a collection of ForEachVariableMapping objects. This class cannot be inherited.
ForLoopProvides a container that defines an iterative workflow in a package, using the for iteration statement.
FtpClientConnectionDownloads and uploads data files and manages directories on servers. This class cannot be inherited.
HResultsContains all event messages and HRESULTs for the Integration Services runtime, pipeline, stock tasks, and stock transforms.
HttpClientConnectionContains 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.
LogEntryInfoContains properties that describe a log entry. This class cannot be inherited.
LogEntryInfoEnumeratorSupports iteration over the LogEntryInfos collection. This class cannot be inherited.
LogEntryInfosContains a collection of LogEntryInfo objects. This class cannot be inherited.
LoggingOptionsContains members that regulate what information is included or excluded from logging. This class cannot be inherited.
LogProviderContains 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.
LogProviderBaseDefines the abstract base class for managed log providers.
LogProviderEnumeratorSupports iteration over the LogProviders collection. This class cannot be inherited.
LogProviderInfoProvides information about the log providers found on the computer. This class cannot be inherited.
LogProviderInfoEnumeratorSupports a simple iteration over the LogProviderInfos collection. This class cannot be inherited.
LogProviderInfosContains a collection of LogProviderInfo objects. This class cannot be inherited.
LogProvidersContains a collection of LogProvider objects associated with the package. This class cannot be inherited.
ManagedForEachEnumeratorWrapper 
ManagedHelper 
ManagedHelper.ManagedPropertyHelper 
ManagedWrapper 
ManagerSerializer 
ObjectReferenceTrackerProvides analysis regarding the impact and consequences of deleting variables and connections from a package. This class cannot be inherited.
PackageRepresents the package container. This class cannot be inherited.
PackageInfoContains 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.
PackageInfoEnumeratorSupports iteration over the PackageInfos collection. This class cannot be inherited.
PackageInfosContains a collection of packages found in Microsoft SQL Server or the Integration Services service. This class cannot be inherited.
PipelineComponentInfoContains properties that describe a pipeline component that is currently installed on the local computer and are ready to be used in a pipeline.
PipelineComponentInfoEnumeratorSupports iteration over the PipelineComponentInfos collection. This class cannot be inherited.
PipelineComponentInfosContains a collection of PipelineComponentInfo objects. This class cannot be inherited.
PrecedenceConstraintSpecifies the properties for configuring a precedence constraint between two containers. This class cannot be inherited.
PrecedenceConstraintEnumeratorSupports a simple iteration over the PrecedenceConstraints collection. This class cannot be inherited.
PrecedenceConstraintsContains a collection of PrecedenceConstraints objects. This class cannot be inherited.
PropertyEnumeratorSupports iteration over the DtsProperties collection. This class cannot be inherited.
RunningPackageProvides a reference to the run-time package to use from the Integration Services service. This class cannot be inherited.
RunningPackagesContains 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.
RunningPackagesEnumeratorSupports iteration over the RunningPackages collection. This class cannot be inherited.
SelectedLogProvidersContains a collection of LogProvider objects. This class cannot be inherited.
SequenceDefines 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.
TaskDefines an abstract class that implements the methods and properties common to all tasks in Integration Services.
TaskHostProvides 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.
TaskInfoContains information about a task installed on the local computer.
TaskInfoEnumeratorSupports iteration over the TaskInfo collection. This class cannot be inherited.
TaskInfosContains a collection of TaskInfo objects. This class cannot be inherited.
VariableRepresents a variable on a package, task, or container. This class cannot be inherited.
VariableDispenserAccesses the Variables collection during package execution. This class cannot be inherited.
VariableEnumeratorSupports iteration over the Variables collection. This class cannot be inherited.
VariablesContains a collection of Variables objects, which are accessed through several objects. This class cannot be inherited.
WarningEnumeratorSupports iteration over the DtsWarnings collection. This class cannot be inherited.
InterfaceDescription
IDTSBreakpointSiteDefines the interaction between the Integration Services run-time engine and the task for exposing breakpoints and for creating and managing custom breakpoints.
IDTSComponentEventsDefines an interface that provides event firing.
IDTSComponentPersistAllows properties and settings for components and tasks to be saved and loaded from the package XML.
IDTSEventsDefines a set of events used by the TaskHost on behalf of a task.
IDTSExecutionMetricsDefines the metrics used to track the execution of a container.
IDTSForEachEnumeratorProvides the methods and properties for the ForEachEnumerator.
IDTSForEachEnumeratorUIContains the members implemented by the ForEachEnumeratorUI user interface class.
IDTSInfoEventsDefines an interface that is used to fire informational, warning, and error events.
IDTSLoggingDefines the logging options for a container.
IDTSManagedTaskDefines an interface implemented on task classes to identify the class as a managed task.
IDTSNameDefines 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.
IDTSObjectHostDefines an interface that allows components to be treated as generic host objects.
IDTSPackagePathDefines an interface implemented by containers that need to have the package path returned into a property.
IDTSPersistDefines an interface that enables saving and loading data.
IDTSPropertiesProviderDefines 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.
IDTSSequenceContains two collections used by containers.
IDTSSuspendProvides methods and properties that are called by the run-time engine to notify tasks to suspend execution.
StructureDescription
DTSEventColumnFilterContains 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.
EnumerationDescription
DTSBreakpointHitTestEnumerates the values for the hit count types. This class works with the BreakpointTarget class.
DTSCheckpointUsageSpecifies values that describe if, or when, a package is restarted.
DTSConfigurationTypeSpecifies the ways that a configuration for a package can be saved.
DTSEventFilterKindDescribes the kind of event filter that is set on logging.
DTSExecResultProvides values that describe the result of a task execution.
DTSExecStatusContains values that indicate the current status of task execution or a container object at the time of the call.
DTSExecutionLocation 
DTSFileConnectionUsageTypeProvides information about how a connection is used by a component client.
DTSForcedExecResultSpecifies the execution result of a container when the container's ForceExecutionValue is set to true.
DTSLogEntryFrequencyProvides 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.
DTSLoggingModeSpecifies 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.
DTSObjectHostTypeDescribes the type of container that is hosting the other task or container.
DTSObjectReferenceTypeSpecifies 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.
DTSPackageInfoFlagsDescribes whether a package is a folder or package. It is used for setting a valid value in the Flags property.
DTSPackageTypeIdentifies the tool that created the package.
DTSPipelineComponentTypeClassifies pipeline components by category.
DTSPrecedenceEvalOpIndicates the evaluation operations that the precedence constraint uses.
DTSPriorityClassDescribes the priority of a thread in a class.
DTSProductLevelSpecifies the SQL Server product edition.
DTSPropertyKindContains values that describe the type of property.
DTSProtectionLevelControls the handling of sensitive information in the package.
DTSProviderSubTypeIdentifies a specific OLE DB provider. The enumeration value also identifies the data type format used by that provider when the ProviderType is OLE DB.
DTSProviderTypeDescribes the kind of provider that is stored.
DTSSignatureStatusDescribes the digital signature.
DTSTransactionOptionDescribes transaction supportability and specifies whether a container participates in transactions.
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.