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.