DTSProviderType Enumeration
Describes the kind of provider that is stored.
Assembly: Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)
| Member name | Description | |
|---|---|---|
| DtsDestination | The provider is a destination. | |
| DtsSource | The provider is a source of data. | |
| Odbc | The provider is an ODBC provider. | |
| OleDb | The provider is an OLEDB provider. | |
| Unknown | The provider is of an unknown type. |
This enumeration is used by the DBProviderInfo class, in the ProviderType property, to indicate what kind of provider the class contains.
The following example enumerates the properties of the database providers available on the computer including the DTSProviderType.
Sample output:
Description = MediaCatalogDB OLE DB Provider, Name = MediaCatalogDB OLE DB Provider, ParseName = {09E767A6-4481-4791-86A5-A739E5290E4C}
ProviderSubType =None, ProviderType = OleDb
SupportsNullColumns = True, UseFullTableName = True
Description = Microsoft OLE DB Provider for SQL Server, Name = SQLOLEDB, ParseName = {0C7FF16C-38E3-11d0-97AB-00C04FC2AD98}
ProviderSubType =SqlServer, ProviderType = OleDb
SupportsNullColumns = True, UseFullTableName = True