PRB: ExOleDB Provider Doesn't Work with SQL Server 2000 DTS Tool (287753)


The information in this article applies to:

  • Microsoft Exchange 2000 Server
  • Microsoft SQL Server 2000 (all editions)
This article was previously published under Q287753

SYMPTOMS

When using the Data Transformation Services (DTS) tool in SQL Server 2000 with the ExOLEDB Provider for Exchange 2000 Server, you are continually prompted to select a SQL Server table. In addition, Exchange public folder information may not be displayed. Therefore, you are not be able to transfer data from an Exchange public folder to a SQL Server table by means of the DTS tool.

CAUSE

The ExOLEDB Provider is not intended to work with DTS, and does not implement all of the required interfaces.

RESOLUTION

To transfer data between Exchange Server 2000 and SQL Server 2000, you must use ExOLEDB to retrieve information from the Exchange store and then send that to SQL Server. Because there are no tools that provide this functionality, this can only be implemented programmatically.

STATUS

This behavior is by design.
Modification Type:MajorLast Reviewed:3/19/2004
Keywords:kbMsg kbprb KB287753
©2004 Microsoft Corporation. All rights reserved.