INFO: Cannot Use OSP Data Providers with SQL DTS (242260)

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.

REFERENCES

For additional information, please click the article number(s) below to view the article(s) in the Microsoft Knowledge Base:

241241 INF: Using DTS With Custom ATL OLE-DB Providers

185822 INFO: Creating Robust OLE DB Providers with OSP

For additional documentation, use the following references:

"Supported OLE DB Interfaces" in the OSP Toolkit documentation in Data Access SDK.The Visual Basic Documentation (c) Microsoft Corporation 1999, All Rights Reserved. Contributions by Ammar Abuthuraya, Microsoft Corporation.