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