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:
property DTSProviderType ProviderType {
	DTSProviderType get();
}

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

No code example is currently available or this language may not be supported.

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

Return to top
Show: