DTSProviderType Enumeration
Describes the kind of provider that is stored.
Namespace: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)
Syntax
'Declaration
Public Enumeration DTSProviderType
public enum DTSProviderType
public enum class DTSProviderType
public enum DTSProviderType
public enum DTSProviderType
Members
| 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. |
Remarks
This enumeration is used by the DBProviderInfo class, in the ProviderType property, to indicate what kind of provider the class contains.
Example
The following example enumerates the properties of the database providers available on the computer including the DTSProviderType.
namespace dbproviderinfo
{
class Program
{
static void Main(string[] args)
{
Application app = new Application();
DBProviderInfos dbis = app.DBProviderInfos;
foreach (DBProviderInfo dbi in dbis)
{
Console.WriteLine("Description = {0}, Name = {1}, ParseName = {2}", dbi.Description, dbi.Name, dbi.ParseName);
Console.WriteLine("ProviderSubType ={0}, ProviderType = {1}", dbi.ProviderSubType, dbi.ProviderType);
Console.WriteLine("SupportsNullColumns = {0}, UseFullTableName = {1}", dbi.SupportsNullColumns, dbi.UseFullTableName);
}
}
}
}
Namespace dbproviderinfo
Class Program
Shared Sub Main(ByVal args() As String)
Dim app As Application = New Application()
Dim dbis As DBProviderInfos = app.DBProviderInfos
Dim dbi As DBProviderInfo
For Each dbi In dbis
Console.WriteLine("Description = {0}, Name = {1}, ParseName = {2}", dbi.Description, dbi.Name, dbi.ParseName)
Console.WriteLine("ProviderSubType ={0}, ProviderType = {1}", dbi.ProviderSubType, dbi.ProviderType)
Console.WriteLine("SupportsNullColumns = {0}, UseFullTableName = {1}", dbi.SupportsNullColumns, dbi.UseFullTableName)
Next
End Sub
End Class
End Namespace
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
Platforms
Development Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.
Target Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.