Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

DTSProviderType Enumeration

Describes the kind of provider that is stored.

Namespace:  Microsoft.SqlServer.Dts.Runtime
Assembly:  Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)
public enum DTSProviderType
Member nameDescription
DtsDestinationThe provider is a destination.
DtsSourceThe provider is a source of data.
OdbcThe provider is an ODBC provider.
OleDbThe provider is an OLEDB provider.
UnknownThe 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.

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);

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

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2014 Microsoft. All rights reserved.