| TABLE 1: OLE DB Interfaces, Properties, and Schemas DTS Uses |
| DataSource |
required property |
| IDBInitialize |
required interface |
| IDBProperties |
required interface |
| IDBCreateSession |
required interface |
| ISessionProperties |
required interface |
| IDBCreateCommand |
optional interface, used to create tables, queries, etc. |
| IDBInfo |
required interface |
| IOpenRowset |
required interface |
| ICommandText |
optional interface, used to create tables, queries, etc. |
| ICommandPrepare |
optional interface, used to create tables, queries, etc. |
| IColumnsInfo |
required interface |
| IRowset |
required interface |
| IAccessor |
required interface |
| ICommandWithParameters |
optional, used for Data Driven Queries |
| IDBSchemaRowset |
required interface |
| DBSCHEMA_PROVIDER_TYPES |
required schema |
| DBSCHEMA_TABLES |
optional schema |
| DBSCHEMA_CATALOGS |
optional schema |
| DBSCHEMA_PRIMARY_KEYS |
optional schema |
| DBSCHEMA_FOREIGN |
optional schema |
| DBSCHEMA_INDEXES |
optional schema |
| DBSCHEMA_TABLE_CONSTRAINTS |
optional schema |
| DBSCHEMA_CHECK_CONSTRAINTS |
optional schema |