Share via

DTSProviderSubType Enumeration

  • Article

This API supports the SQL Server 2012 infrastructure and is not intended to be used directly from your code.

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.

Namespace:  Microsoft.SqlServer.Dts.Runtime.Wrapper
Assembly:  Microsoft.SqlServer.DTSRuntimeWrap (in Microsoft.SqlServer.DTSRuntimeWrap.dll)

Syntax

'Declaration
Public Enumeration DTSProviderSubType
'Usage
Dim instance As DTSProviderSubType

public enum DTSProviderSubType

public enum class DTSProviderSubType

type DTSProviderSubType

public enum DTSProviderSubType

Members

Member name Description
DTSPST_ACCESS The provider is the Microsoft OLE DB Provider for Microsoft Jet 4.0.
DTSPST_DB2 The provider is Microsoft OLE DB Provider for DB2.
DTSPST_DBASE The provider is dBASE.
DTSPST_EXCEL The provider is the Microsoft OLE DB Provider for Microsoft Jet 4.0.
DTSPST_FLATFILE The provider is a flat file.
DTSPST_NONE The provider is not specified using this enumeration.
DTSPST_ORACLE The provider is Microsoft OLE DB Provider for Oracle. This provider supports versions up to Oracle 8.
DTSPST_PARADOX The provider is Corel Paradox.
DTSPST_SQLSERVER The provider is Microsoft SQL Server Native Client OLE DB Provider.

Remarks

For more information, see DTSProviderSubType.

See Also

Reference

Microsoft.SqlServer.Dts.Runtime.Wrapper Namespace