Microsoft KB Archive/242260

= INFO: Cannot Use OSP Data Providers with SQL DTS =

Article ID: 242260

Article Last Modified on 10/17/2003

-

APPLIES TO


 * OLE DB Simple Provider Toolkit 2.0
 * OLE DB Simple Provider Toolkit 2.0
 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q242260



SUMMARY
The OLE DB Simple Provider (OSP) Toolkit is geared toward making simple OLE DB data providers. It basically exposes core OLE DB interfaces and capabilities. The default implementation of such a simple OLE DB data provider will not work with the Data Transformation Services (DTS) provided by SQL Server 7.0.

This article describes the limitation of using the OSP data providers with DTS in SQL Server 7.0.



MORE INFORMATION
In order to use any OLE DB provider with DTS through the DTS Designer and DTS Wizard, the following OLE DB interfaces must be implemented in the Data Provider:   IDBInitialize IDBProperties IDBCreateSession ISessionProperties IDBInfo IColumnsInfo IRowset IAccessor IOpenRowset IDBSchemaRowset ITransactionJoin: If using transactions across steps However, the OSP Toolkit does not expose the following Extended OLE DB interfaces that must be supported when using DTS:

  IDBInfo IDBSchemaRowset ITransactionJoin

In order to use your OLE DB provider within the Data Transformation Services, you should consider building an OLE DB provider using Microsoft Visual C++ rather than with the OSP interfaces. Although writing providers with Microsoft Visual C++ involves a greater development effort, the providers you write will provide you with greater extensibility and a richer set of OLE DB data manipulation routines.

