DBProviderInfo.ProviderType Property

Returns a DTSProviderType enumeration that describes the type of provider in terms of the provider being a source or destination provider. This field is read-only.

Namespace: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)

public DTSProviderType ProviderType { get; }
/** @property */
public DTSProviderType get_ProviderType ()

public function get ProviderType () : DTSProviderType

Property Value

A DTSProviderType enumeration.

The following example enumerates the properties of the database providers available on the computer.

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

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

Community Additions