DTS Programming
ProviderID Property
The ProviderID property returns the program ID of the OLE DB provider.
Applies To
Connection Object | Connection2 Object |
Syntax
object.ProviderID
Part | Description |
---|---|
object | Expression that evaluates to an object in the Applies To list |
Data Type
String
Modifiable
Read-only
Prototype (C/C++)
HRESULT GetProviderID(BSTR *pRetVal);
Remarks
A user-implemented OLE DB provider must support the following features if it is to be used with Data Transformation Services (DTS):
Interfaces
This is the interface support that DTS requires.
Interface | Requirement |
---|---|
IDBInitialize | Necessary. |
IDBProperties | Necessary. |
IDBCreateSession | Necessary. |
ISessionProperties | Necessary. |
IDBCreateCommand | Optional (for example, used for create table and queries). |
IDBInfo | Necessary. |
IOpenRowset | Necessary. |
ICommandText | Optional (for example, used for create table and queries). |
ICommandPrepare | Optional (for example, used for create table and queries). |
IColumnsInfo | Necessary. |
IRowset | Necessary. |
IAccessor | Necessary. |
ICommandWithParameters | Optional. Used for data driven queries. |
IDBSchemaRowset | Necessary. |
In addition to these interfaces, the DTS package requires that a provider have a DataSource property.
Schema
These are the schema that DTS requests:
- DBSCHEMA_TABLES
- DBSCHEMA_CATALOGS
- DBSCHEMA_PROVIDER_TYPES. This is the only one that must be supported.
- DBSCHEMA_PRIMARY_KEYS
- DBSCHEMA_FOREIGN_KEYS
- DBSCHEMA_INDEXES
- DBSCHEMA_TABLE_CONSTRAINTS
- DBSCHEMA_CHECK_CONSTRAINTS