共用方式為


Microsoft.SqlServer.Dts.Runtime 命名空間

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

類別

  類別 說明
公用類別 Application Discovers and accesses Package objects. It can also access collections and properties that contain information about the system.
公用類別 BatchUpgradeOptions Specifies the options that the Upgrade 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.
公用類別 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 Contains all event messages and HRESULTs for the Integration Services runtime, pipeline, stock tasks, and stock transforms.
公用類別 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.
公用類別 LogProviderEnumerator Supports iteration over the LogProviders collection. This class cannot be inherited.
公用類別 LogProviderInfo Provides information about the log providers found on the computer. This class cannot be inherited.
公用類別 LogProviderInfoEnumerator Supports a simple iteration over the LogProviderInfos collection. This class cannot be inherited.
公用類別 LogProviderInfos Contains a collection of LogProviderInfo objects. This class cannot be inherited.
公用類別 LogProviders Contains a collection of LogProvider objects associated with the package. This class cannot be inherited.
公用類別 ManagedForEachEnumeratorWrapper 基礎結構。Represents the wrapper for the managed For Each enumerator. This class cannot be inherited.
公用類別 ManagedHelper 基礎結構。Represents the managed helper.
公用類別 ManagedHelper.ManagedPropertyHelper 基礎結構。Represents the managed property header.
公用類別 ManagedWrapper 基礎結構。Represents the managed wrapper.
公用類別 ManagerSerializer 基礎結構。Represents the manager serializer.
公用類別 NameChecker Represents the name checker.
公用類別 ObjectReferenceTracker Provides analysis regarding the impact and consequences of deleting variables and connections from a package. This class cannot be inherited.
公用類別 Package Represents the package container. This class cannot be inherited.
公用類別 PackageInfo 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.
公用類別 PackageInfoEnumerator Supports iteration over the PackageInfos collection. This class cannot be inherited.
公用類別 PackageInfos Contains a collection of packages found in Microsoft SQL Server or the Integration Services service. This class cannot be inherited.
公用類別 PackageItem Contains package related information including the package and state.
公用類別 PackageItems Contains a collection of PackageItem objects.
公用類別 PackageParameterEnumerator Represents the package parameter enumerator.
公用類別 PackageUpgradeOptions Specifies the options to be applied when an Integration Services package is upgraded.
公用類別 PackageUpgradeResult Specifies the upgrade results for a package.
公用類別 Parameter Represents an abstract base class used by both package parameter and project parameter.
公用類別 ParameterInfo Represents a read only copy of the parameter information so that applications can get parameter information without having to load the whole package object.
公用類別 ParameterInfos Represents a collection of parameter objects.
公用類別 Parameters Represents a class used by both the package parameters and project parameters collection.
公用類別 PipelineComponentInfo Contains properties that describe a pipeline component that is currently installed on the local computer and are ready to be used in a pipeline.
公用類別 PipelineComponentInfoEnumerator Supports iteration over the PipelineComponentInfos collection. This class cannot be inherited.
公用類別 PipelineComponentInfos Contains a collection of PipelineComponentInfo objects. This class cannot be inherited.
公用類別 PrecedenceConstraint Specifies the properties for configuring a precedence constraint between two containers. This class cannot be inherited.
公用類別 PrecedenceConstraintEnumerator Supports a simple iteration over the PrecedenceConstraints collection. This class cannot be inherited.
公用類別 PrecedenceConstraints Contains a collection of PrecedenceConstraint objects. This class cannot be inherited.
公用類別 Project Represents Integration Services project which contains packages and parameters.
公用類別 ProjectVariablesWrapper Contains a collection of project variables wrapper.
公用類別 PropertyEnumerator Supports iteration over the DtsProperties collection. This class cannot be inherited.
公用類別 RunningPackage Provides a reference to the run-time package to use from the Integration Services service. This class cannot be inherited.
公用類別 RunningPackages 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.
公用類別 RunningPackagesEnumerator Supports iteration over the RunningPackages collection. This class cannot be inherited.
公用類別 SelectedLogProviders Contains a collection of selected LogProvider objects. This class cannot be inherited.
公用類別 Sequence 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.
公用類別 SsisServerExecution Represents the SSIS server execution.
公用類別 StorageInfo Provides information about the storage location for either the original or the upgraded Integration Services packages.
公用類別 Task Defines an abstract class that implements the methods and properties common to all tasks in Integration Services. 
公用類別 TaskHost 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.
公用類別 TaskInfo Contains information about a task installed on the local computer.
公用類別 TaskInfoEnumerator Supports iteration over the TaskInfo collection. This class cannot be inherited.
公用類別 TaskInfos Contains a collection of TaskInfo objects. This class cannot be inherited.
公用類別 UpgradePackageInfo Stores information about an Integration Services package that is to be upgraded.
公用類別 UpgradeResult Determines the result of upgrading a collection of Integration Services packages.
公用類別 Variable Represents a variable on a package, task, or container. This class cannot be inherited.
公用類別 VariableDispenser Accesses the Variables collection during package execution. This class cannot be inherited.
公用類別 VariableEnumerator Supports iteration over the Variables collection. This class cannot be inherited.
公用類別 Variables Contains a collection of Variables objects, which are accessed through several objects. This class cannot be inherited.
公用類別 WarningEnumerator Supports iteration over the DtsWarnings collection. This class cannot be inherited.

結構

  結構 說明
公用結構 DTSEventColumnFilter 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.
公用結構 StatusMessage Specifies the warning and error messages that result from upgrading an Integration Services package.

介面

  介面 說明
公用介面 IDTSBreakpointSite Defines the interaction between the Integration Services run-time engine and the task for exposing breakpoints and for creating and managing custom breakpoints.
公用介面 IDTSComponentEvents Defines an interface that provides event firing.
公用介面 IDTSComponentPersist Allows properties and settings for components and tasks to be saved and loaded from the package XML.
公用介面 IDTSConfigurationControl Provides a property that controls how a package loads configurations.
公用介面 IDTSDowngradableObject 基礎結構。Represents the interface for the DTS downgradable object.
公用介面 IDTSDumpConfiguration Represents the configuration for the dumping of Data Transformation Service interface.
公用介面 IDTSEvents Defines a set of events used by the TaskHost on behalf of a task.
公用介面 IDTSExecutionMetrics Defines the metrics used to track the execution of a container.
公用介面 IDTSExecutionPath Represents the DTS execution path.
公用介面 IDTSForEachEnumerator Provides the methods and properties for the ForEachEnumerator.
公用介面 IDTSForEachEnumeratorUI Contains the members implemented by the ForEachEnumeratorUI user interface class.
公用介面 IDTSInfoEvents Defines an interface that is used to fire informational, warning, and error events.
公用介面 IDTSLogging Defines the logging options for a container.
公用介面 IDTSManagedTask Defines an interface implemented on task classes to identify the class as a managed task.
公用介面 IDTSName 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.
公用介面 IDTSObjectHost Defines an interface that allows components to be treated as generic host objects.
公用介面 IDTSPackageInternal 基礎結構。Defines an interface implemented by containers that need to have the internal property.
公用介面 IDTSPackagePath Defines an interface implemented by containers that need to have the package path returned into a property.
公用介面 IDTSPersist Defines an interface that enables saving and loading data.
公用介面 IDTSPropertiesProvider 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.
公用介面 IDTSPropertiesProviderEx Represents the DTS properties provider expressions.
公用介面 IDTSSequence Contains two collections used by containers.
公用介面 IDTSSuspend Provides methods and properties that are called by the run-time engine to notify tasks to suspend execution.

列舉

  列舉 說明
公用列舉 ActionOnExistType Defines the behavior that occurs when an upgrade package has the same name as an existing Integration Services package.
公用列舉 ConnectionManagerItemState Specifies the state of the connection manager item.
公用列舉 DTSBreakpointHitTest Enumerates the values for the hit count types. This class works with the BreakpointTarget class.
公用列舉 DTSCheckpointUsage Specifies values that describe if, or when, a package is restarted.
公用列舉 DTSConfigurationType Specifies the ways that a configuration for a package can be saved.
公用列舉 DTSConnectionManagerScope Specifies the DTS connection manager scope.
公用列舉 DTSEventFilterKind Describes the kind of event filter that is set on logging.
公用列舉 DTSExecResult Provides values that describe the result of a task execution.
公用列舉 DTSExecStatus Contains values that indicate the current status of task execution or a container object at the time of the call.
公用列舉 DTSExecutionLocation 基礎結構。Specifies the DTS execution location.
公用列舉 DTSFileConnectionUsageType Provides information about how a connection is used by a component client.
公用列舉 DTSForcedExecResult Specifies the execution result of a container when the container's ForceExecutionValue is set to true.
公用列舉 DTSLogEntryFrequency 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.
公用列舉 DTSLoggingMode 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.
公用列舉 DTSObjectHostType Describes the type of container that is hosting the other task or container.
公用列舉 DTSObjectReferenceType 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.
公用列舉 DTSPackageInfoFlags Describes whether a package is a folder or package. It is used for setting a valid value in the Flags property.
公用列舉 DTSPackageType Identifies the tool that created the package.
公用列舉 DTSPipelineComponentType Classifies pipeline components by category.
公用列舉 DTSPrecedenceEvalOp Indicates the evaluation operations that the precedence constraint uses.
公用列舉 DTSPriorityClass Describes the priority of a thread in a class.
公用列舉 DTSProductLevel Specifies the SQL Server product edition. 
公用列舉 DTSPropertyKind Contains values that describe the type of property.
公用列舉 DTSProtectionLevel Controls the handling of sensitive information in the package.
公用列舉 DTSProviderSubType 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.
公用列舉 DTSProviderType Describes the kind of provider that is stored.
公用列舉 DTSServerParameterType Specifies the DTS server parameter type.
公用列舉 DTSSignatureStatus Describes the status of the digital signature.
公用列舉 DTSTransactionOption Describes transaction supportability and specifies whether a container participates in transactions.
公用列舉 NameCheckResult Specifies the result of a name check.
公用列舉 PackageItemState Specifies the state of a package item.
公用列舉 Project.AccessMode Defines the constants for read-only or read/write access to a project.
公用列舉 ProjectStorageAttributes Specifies the attributes of project storage.
公用列舉 StorageType Defines the type of storage to which upgraded Integration Services packages will be saved.
公用列舉 UpgradeResultStatus Defines the results of upgrading an Integration Services package.