共用方式為


Microsoft.SqlServer.Dts.Runtime.Wrapper Namespace

The Microsoft.SqlServer.Dts.Runtime.Wrapper namespace provides the classes and interfaces used to create Control Flow components in the runtime. This assembly is a Primary Interop Assembly (PIA) for the namespace Microsoft.SqlServer.Dts.Runtime, which is the assembly Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll). The classes in this namespace should not be instantiated. Instead, use the classes found in the Microsoft.SqlServer.Dts.Runtime.

Classes

ApplicationClass

Discovers and accesses Package objects.

ConnectionManagerAdoClass

Provides the connection information to a data source.

ConnectionManagerAdoNetClass

Represents a connection manager that utilizes .Net provider for the data connection.

ConnectionManagerCacheClass

Represents a connection manager that utilizes a Cache Transform or a cache file for the data connection.

ConnectionManagerExcelClass

Represents a connection manager that connects to an Excel workbook file.

ConnectionManagerFileClass

Represents a connection manager class.

ConnectionManagerFlatFileClass

Represents a connection manager flat file class.

ConnectionManagerFtpClass

Represents a connection manager FTP class.

ConnectionManagerHostClass

Represents a connection manager that connects to a task host.

ConnectionManagerHttpClass

Represents a connection manager http class.

ConnectionManagerMultiFileClass

Represents a connection manager multi-file class.

ConnectionManagerMultiFlatFileClass

Represents a connection manager for accessing multiple flat files.

ConnectionManagerOdbcClass

Represents a connection manager that connects to a data source using ODBC.

ConnectionManagerOLAPClass

Represents a connection manager OLAP class.

ConnectionManagerOleDbClass

Represents a connection manager that connects to a data source using OLE DB provider.

ConnectionManagerSqlMobileClass

Represents a connection manager sql mobile class.

EventHandlerClass

A container on a package or other containers that holds executable objects to run when specific events occur.

ExpressionEvaluatorClass

Provides virtual properties and methods for IDTSExpressionEvaluator100 interface.

ForEachEnumeratorHostClass

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

ForEachItemEnumeratorClass

Implements an enumerator over the IDTSForEachItem100 collection.

ForEachLoopClass

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

ForLoopClass

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

FTPClientConnection100Class

Provides properties and methods for an FTP client task.

HttpClientConnection100Class

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.

LogProviderEventLogClass

Represents a class for the LogProviderEventLog interface.

LogProviderHostClass

Represents a class for the LogProviderHost interface.

LogProviderSQLProfilerClass

Represents a class for the LogProviderSQLProfiler interface.

LogProviderSQLServerClass

Represents a class for the LogProviderSQLServer interface.

LogProviderTextFileClass

Represents a class for the LogProviderTextFile interface.

LogProviderXMLFileClass

Represents a class for the LogProviderXMLFile interface.

PackageClass

Represents a class for the Package interface.

PackageNeutralClass

Represents a class for a neutral package.

PackageRemote32Class

Represents a class for a remote 32-bit package.

PackageRemote64Class

Represents a class for a remote 64 bit package.

ParameterClass

Represents a parameter class.

PrecedenceConstraintClass

For more information, see PrecedenceConstraint.

ProjectConnectionsCreatorClass

Represents the project connections creator class.

ProjectConnectionsCreatorNeutralClass

Represents the project connections creator neutral class.

PropertiesClass
ReplacementTaskClass

Represents a replacement task class.

SequenceClass

Represents a sequence class.

TaskCreator32Class

Represents a 32-bit task creator class.

TaskCreator64Class

Represents a task creator class.

TaskHostClass

For more information, see TaskHost.

VariableClass

Represents a variable class.

VariableCreatorClass

Represents a variable creator class.

VariableDispenserClass

Represents a variable dispenser class.

Structs

_FILETIME

Specifies the file time for the runtime.

_LARGE_INTEGER

Specifies the large integer for the runtime wrapper.

_ULARGE_INTEGER

Provides a 64-bit data type which is accessible as two DWORDs or as a single DWORDLONG.

DTP_DATA_UNION

Specifies a union data types.

DTP_DBDATE

Specifies an enumeration of date structure.

DTP_DBTIME

Specifies a data type time structure.

DTP_DBTIME2

Specifies a time structure that consists of hour, minute, second, and fractional seconds.

DTP_DBTIMESTAMP

A timestamp structure that consists of year, month, day, hour, minute, second, and fractional seconds. The fractional seconds have a maximum scale of 3 digits.

DTP_DBTIMESTAMP2

A timestamp structure that consists of year, month, day, hour, minute, second, and fractional seconds. The fractional seconds have a maximum scale of 7 digits.

DTP_DBTIMESTAMPOFFSET

A timestamp structure that consists of year, month, day, hour, minute, second, and fractional seconds, and has a time zone offset from the Coordinated Universal Time (UTC) that is used to obtain the local time. The fractional seconds have a maximum scale of 7 digits.

DTP_FILETIME

Specifies an enumeration of data filetime structure.

DTP_NUMERIC

Specifies an enumeration of data numeric structure.

DTP_VARIANT

Specifies the data type of the column. This is a value from the DataType enumeration that determines the type of DTP_VARIANT structure stored in each cell of this column.

DTS_CLASS_INFO
DTS_EVENT_COLUMN_FILTER

For more information, see DTSEventColumnFilter.

DTS_EXTENSION_MAPPING_INFO

Enumerates the extension mapping information.

DTS_MANAGED_INFO

Specifies a data managed information structure.

DTS_MANAGED_PROPERTY

Specifies an enumeration of managed data property.

DTS_PACKAGE_UPGRADE_OPTIONS

A structure used for specifying options during a package upgrade.

tagSTATSTG

Specifies the statistical information about an open storage, stream, or byte array object.

Interfaces

Application

For more information, see ApplicationClass.

ConnectionManagerAdo

For more information, see ConnectionManagerAdoClass.

ConnectionManagerAdoNet

For more information, see ConnectionManagerAdoNetClass.

ConnectionManagerCache

For more information, see ConnectionManagerCacheClass.

ConnectionManagerExcel

For more information, see ConnectionManagerExcelClass.

ConnectionManagerFile

For more information, see ConnectionManagerFileClass.

ConnectionManagerFlatFile

For more information, see ConnectionManager.

ConnectionManagerFtp

For more information, see ConnectionManagerFtpClass.

ConnectionManagerHost

For more information, see ConnectionManagerHostClass.

ConnectionManagerHttp

For more information, see ConnectionManagerHttpClass.

ConnectionManagerMultiFile

For more information, see ConnectionManagerMultiFileClass.

ConnectionManagerMultiFlatFile

For more information, see ConnectionManagerMultiFlatFileClass.

ConnectionManagerOdbc

For more information, see ConnectionManagerOdbcClass.

ConnectionManagerOLAP

For more information, see ConnectionManagerOLAPClass.

ConnectionManagerOleDb

For more information, see ConnectionManagerOleDbClass.

ConnectionManagerSqlMobile

For more information, see ConnectionManagerSqlMobileClass.

EventHandler

For more information, see EventHandlerClass.

ExpressionEvaluator

For more information, see ExpressionEvaluatorClass.

ForEachEnumeratorHost

For more information, see ForEachEnumeratorHostClass.

ForEachItemEnumerator

For more information, see ForEachItemEnumeratorClass.

ForEachLoop

For more information, see ForEachLoopClass.

ForLoop

For more information, see ForLoopClass.

FTPClientConnection100

For more information, see IDTSFtpClientConnection100.

HttpClientConnection100

For more information, see HttpClientConnection100Class.

IDTSAccessTokenProvider140
IDTSApplication100

Provides properties and methods that are used to discover and access Package objects.

IDTSApplication130
IDTSApplication150
IDTSBreakpointManager100

Provides methods to manage all the breakpoints that are set in on a task.

IDTSBreakpointSite100

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

IDTSBreakpointTarget100

For more information, see BreakpointTarget.

IDTSBreakpointTargets100

Provides properties and methods for working on a collection of IDTSBreakpointTarget100 objects.

IDTSCloneVariableDispenser100

Represents cloned copy of an original variable dispenser object.

IDTSComponentEvents100

Defines an interface that provides methods for event firing.

IDTSComponentPersist100

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

IDTSComponentPersist130
IDTSConfiguration100

For more information, see Configuration.

IDTSConfigurationControl100

Provides a property that controls how a package loads configurations.

IDTSConfigurations100

Represents a collection of IDTSConfiguration100 objects.

IDTSConnectionInfo100

For more information, see ConnectionInfo.

IDTSConnectionInfos100

Contains information about all the connections on the computer. The collection contains IDTSConnectionInfo100 objects that provide the details about each connection. The collection is available using the ApplicationClass class.

IDTSConnectionManager100

Provides properties and methods that are used for managing connection to a data source.

IDTSConnectionManagerCache100

Provides properties and methods associated with managing connections using a Cache Transform or a cache file for the data connection.

IDTSConnectionManagerCacheColumn100

For more information, see ConnectionManager.

IDTSConnectionManagerCacheColumns100

Provides properties and methods for working on a collection of IDTSConnectionManagerCacheColumn100 objects.

IDTSConnectionManagerDatabaseParameters100

For more information, see ConnectionManager.

IDTSConnectionManagerEnableStaging140
IDTSConnectionManagerExcel100

For more information, see ConnectionManagerExcelClass.

IDTSConnectionManagerFile100

For more information, see ConnectionManagerFileClass.

IDTSConnectionManagerFlatFile100

This interface is used by the native connection managers. For more information, see ConnectionManagerFlatFileClass and ConnectionManagerMultiFlatFileClass.

IDTSConnectionManagerFlatFileColumn100

For more information, see FlatFileColumn.

IDTSConnectionManagerFlatFileColumns100

Represents a collection of IDTSConnectionManagerFlatFileColumn100 objects.

IDTSConnectionManagerFtp100

For more information, see ConnectionManagerFtpClass.

IDTSConnectionManagerHttp100

Represents a connection manager for HTTP connection.

IDTSConnectionManagerInit100

Provides methods for initializing the properties of a connection manager.

IDTSConnectionManagerManagedIdentity140
IDTSConnectionManagerMarshalControl100

Provides properties and methods to connection manager that supports marshal control.

IDTSConnectionManagerVariables100

Provides variables and variable dispenser to connection manager.

IDTSConnections100

Provides properties and methods for working on a collection of connection managers.

IDTSContainer100

Defines properties and methods used by all containers and packages.

IDTSDataTapConfiguration100

Provides methods for working with a data tap configuration.

IDTSDataTypeInfo100

For more information, see DataTypeInfo.

IDTSDataTypeInfos100

Contains a collection of IDTSDataTypeInfo100 objects.

IDTSDBProviderInfo100

For more information, see DBProviderInfo.

IDTSDBProviderInfos100

Contains a collection of IDTSDBProviderInfo100 objects.

IDTSDowngradableObject100

Represents the interface for the DTS downgradable object.

IDTSDowngradeSettings100

Represents the downgrade settings.

IDTSDumpConfiguration100

Represents a dump configuration for the DTS.

IDTSDynamicName100

Represents the dynamic name for the DTS.

IDTSEnumReferencedObjects100

For more information, see EnumReferencedObjects.

IDTSError100

For more information, see DtsError.

IDTSErrors100

Represents a collection of IDTSError100 objects.

IDTSEvaluatorContext100

Represents the interface for the DTS evaluator context.

IDTSEventHandler100

For more information, see EventHandler.

IDTSEventHandlers100

Represents a collection of IDTSEventHandler100 objects.

IDTSEventInfo100

For more information, see EventInfo.

IDTSEventInfos100

Represents a collection of IDTSEventInfo100 objects.

IDTSEvents100

Defines methods for the events.

IDTSEventsProvider100

For more information, see EventsProvider.

IDTSExecutable100

Represents an interface that provides the methods that all objects that are run by the run-time engine are required to inherit and implement.

IDTSExecutables100

Represents a collection of IDTSExecutable100 objects.

IDTSExecutionLocation100

For more information, see TaskHost.

IDTSExecutionMetrics100

For more information, see IDTSExecutionMetrics.

IDTSExecutionPath100

For more information, see IDTSExecutionPath.

IDTSExpression100

Represents the interface for the expression.

IDTSExpressionEvaluator100

Defines the properties and methods for the ExpressionEvaluator object.

IDTSExtendedProperties100

Represents a collection of IDTSExtendedProperty100 objects.

IDTSExtendedProperty100

For more information, see ExtendedProperty.

IDTSForEachEnumerator100

Defines the properties and methods for the ForEachEnumerator.

IDTSForEachEnumeratorInfo100

For more information, see ForEachEnumeratorInfo.

IDTSForEachEnumeratorInfos100

Represents the interface for the collection of ForEachEnumeratorInfo objects.

IDTSForEachItem100

Represents an interface for the ForEachItem object.

IDTSForEachItemEnumerator100

Represents an interface of the ForEachItemEnumerator object.

IDTSForEachItems100

Represents an interface for the ForEachItems object.

IDTSForEachItemsProvider100

For more information, see ForEachItemValueEnumerator.

IDTSForEachItemValue100

For more information, see ForEachItemValue.

IDTSForEachLoop100

Represents an interface that defines the ForEach loop process.

IDTSForEachVariableMapping100

For more information, see ForEachVariableMapping.

IDTSForEachVariableMappings100

Represents an interface of the ForEachVariableMappings object.

IDTSForLoop100

Represents an interface for the ForLoop process.

IDTSFtpClientConnection100

Represents the interface for the FTP Client Connection.

IDTSHasInternalProperties100

Represents a DTS internal properties.

IDTSHttpClientConnection100

For more information, see HttpClientConnection100Class.

IDTSInfoEvents100

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

IDTSLogEntryInfo100

For more information, see LogEntryInfo.

IDTSLogEntryInfos100

For more information, see LogEntryInfos.

IDTSLogging100

Defines the logging options for the container.

IDTSLoggingOptions100

Represents an interface of the DTS logging options.

IDTSLogProvider100

Implements an interface of a log provider.

IDTSLogProviderInfo100

For more information, see LogProviderInfo.

IDTSLogProviderInfos100

For more information, see LogProviderInfos.

IDTSLogProviderInit100

Represents an initialized log provider.

IDTSLogProviders100

Represents an interface of log providers.

IDTSManagedForEachEnumeratorWrapper100

Describes the interface for the ForEach enumerator wrapper.

IDTSManagedHelper100

Specifies an interface of the managed helper.

IDTSManagedHelper140
IDTSManagedHelper150
IDTSManagedPropertyHelper100

Represents a managed property helper.

IDTSManagedSerializer100

Describes the interface for the managed serializer.

IDTSManagedTask100

For more information, see IDTSManagedTask.

IDTSManagedWrapper100

Represents a DTS managed wrapper.

IDTSManagedXmlSerializationHelper100

Describes the interface for the XML serialization helper.

IDTSName100

For more information, see IDTSName.

IDTSObjectHost100

For more information, see TaskHost.

IDTSObjectReferenceTracker100

Provides an interface for the analysis regarding the impact and consequences of deleting variables and connections from a package.

IDTSObjectVersionUpdate100

Represents an interface for the version update of data transformatioon services object.

IDTSODBCHandles100

Defines the native interface for the ODBC connection. A reference to this interface is returned from the AcquireConnection(Object) method when the ConnectionManager is of type ODBC.

IDTSODBCHandles130
IDTSPackage100

Represents an interface implemented by the Package and PackageNeutral interfaces.

IDTSPackageInfo100

For more information, see PackageInfo.

IDTSPackageInfos100

Provides properties and methods for working on a collection of IDTSPackageInfo100 objects.

IDTSPackageInternal100

Represents an interface implemented by the collection of IDTSPackageInternal100 container that need to have the internal property.

IDTSPackagePath100

For more information, see IDTSPackagePath.

IDTSPackagePersist100

Defines methods for the persistence of the package.

IDTSPackagePersist130
IDTSPackageSigning100

Represents an interface for the package signing.

IDTSPackageVersionUpdate100

Defines a method for the update of the package version.

IDTSPackageVersionUpdate130
IDTSParameter100

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

IDTSParameters100

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

IDTSPerfRecorder100

Represents the interface for the performance recorder.

IDTSPersist100

Represents an interface that enables IDTSPersist100 saving and loading data. For more information, see IDTSPersist.

IDTSPersist130
IDTSPipelineComponentInfo100

For more information, see PipelineComponentInfo.

IDTSPipelineComponentInfos100

Provides properties and methods for working on a collection of IDTSPipelineComponentInfo100 objects.

IDTSPrecedenceConstraint100

For more information, see PrecedenceConstraintClass.

IDTSPrecedenceConstraints100

Provides properties and methods for working on a collection of IDTSPrecedenceConstraint100 objects.

IDTSProductLevel100

For more information, see DTSProductLevel.

IDTSProject100

Represents an interface which contains packages and parameters.

IDTSProjectAccessor100

Represents an interface for the DTS project assessor.

IDTSProjectAccessor150
IDTSProjectConnectionsCreator100

Represents a connections creator of a DTS project.

IDTSProjectPackage100

Represents a DTS project which contains packages.

IDTSProperties100

Contains a collection of IDTSProperty100 objects.

IDTSProperties130
IDTSPropertiesProvider100

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.

IDTSPropertiesProviderEx100

Represents the DTS properties provider expressions.

IDTSProperty100

Represents an interface for the DtsProperty object.

IDTSRunningPackage100

For more information, see RunningPackage.

IDTSRunningPackages100

Contains a collection of IDTSRunningPackage100 objects.

IDTSRuntimeObject100

This interface is inherited by native classes that are containers, and implemented by all objects in the Microsoft.SqlServer.Dts.Runtime namespace. For more information, see DtsObject.

IDTSSelectedLogProviders100

Defines an interface for a collection of selected IDTSLogProvider100 objects.

IDTSSequence100

For more information, see Sequence.

IDTSServerExecution100

Represents an instance of execution in the Integration Services catalog.

IDTSServerUsageControl100

Provides properties for controlling DTS server usage.

IDTSSupportAccessTokenProvider140
IDTSSupportDataTapConfiguration100

Provides methods for accessing data tap configuration.

IDTSSupportOffline100

Provides properties for indicating whether DTS connection supports offline mode.

IDTSSupportParentExecutionPath100

Represents the support for the parent execution path.

IDTSSupportPerfRecorder100

Represents the interface for the support for the performance recorder.

IDTSSupportTargetServerVersion130
IDTSSupportVerboseLogging100

Defines methods for accessing the verbose logging.

IDTSSuspend100

For more information, see IDTSSuspend.

IDTSTask100

Defines a property and methods for all the tasks in Integration Services.

IDTSTaskCreator100

Represents an interface for the creator of a task.

IDTSTaskHost100

For more information, see TaskHostClass.

IDTSTaskInfo100

For more information, see TaskInfo.

IDTSTaskInfos100

Contains a collection of IDTSTaskInfo100 objects.

IDTSTaskInit100

Defines a method for the task to initialize.

IDTSTelemetry130
IDTSTelemetry140
IDTSUnsafeVariables100

Defines methods for all unsafe variables.

IDTSVariable100

Represents an interface for the variable on a package, task or container.

IDTSVariableCreator100

Represents an interface for the creator of a variable.

IDTSVariableDispenser100

Represents a variable dispenser class. For more information, see VariableDispenserClass.

IDTSVariableLock100

Defines methods for the lock of variable.

IDTSVariables100

Provides properties and methods for working on a collection of IDTSVariable100 objects.

IDTSWarning100

For more information, see DtsWarning.

IDTSWarnings100

Defines a properties and methods for the collection of warning.

ISequentialStream

Defines methods for the stream objects in sequence.

IStream

Provides an interface that supports reading and writing data to stream objects.

ITaskSupportProject100

Defines method for the task that supports a project.

LogProviderEventLog

For more information, see LogProviderEventLogClass.

LogProviderHost

For more information, see LogProviderHostClass.

LogProviderSQLProfiler

For more information, see LogProviderSQLProfilerClass.

LogProviderSQLServer

For more information, see LogProviderSQLServerClass.

LogProviderTextFile

For more information, see LogProviderTextFileClass.

LogProviderXMLFile

For more information, see LogProviderXMLFileClass.

Package

For more information, see PackageClass.

PackageNeutral

For more information, see PackageNeutralClass.

PackageRemote32

Represents an interface for a remote 32-bit package.

PackageRemote64

Represents an interface for a remote 64-bit package.

Parameter

For more information, see ParameterClass.

PrecedenceConstraint

For more information, see PrecedenceConstraintClass.

ProjectConnectionsCreator

For more information, see ProjectConnectionsCreatorClass.

ProjectConnectionsCreatorNeutral

For more information, see ProjectConnectionsCreatorNeutralClass.

Properties
ReplacementTask

For more information, see ReplacementTaskClass.

Sequence

For more information, see SequenceClass.

TaskCreator32

Represents a 32-bit task creator.

TaskCreator64

Represents a task creator class.

TaskHost

For more information, see TaskHostClass.

Variable

For more information, see VariableClass.

VariableCreator

Represents the creator of a variable.

VariableDispenser

For more information, see VariableDispenserClass.

Enums

DataType

Indicates the data type of columns in data flow components and the data flow buffer.

DTS_MANAGED_INFO_TYPE

An enumeration that specifies the managed data type information.

DTSBreakpointHitTest

Enumerates the values for the hit count types.

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

For more information, see DTSConnectionManagerScope. Specifies the scope levels of a connection manager.

DTSEvaluatorContextOption

Specifies the options for the evaluator context.

DTSEventFilterKind

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

DTSExcelVersion

This enumeration maps the Extended Properties from the connection string in an OLEDB provider to the correct version of the Excel connection manager. For more information, see ConnectionManagerExcelClass.

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 values that correspond to a log scheme used to assist in log planning.

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(Object) method.

DTSPackageInformationFlags

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.

DTSTargetServerVersion
DTSTransactionOption

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

Remarks

For information on Primary Interop Assemblies and how the managed classes work with the wrapper classes, see "COM Wrappers" and "Exposing .NET Framework Components to COM" in the .NET Framework Developer's Guide in the MSDN Library.