Microsoft KB Archive/287753

= PRB: ExOleDB Provider Doesn't Work with SQL Server 2000 DTS Tool =

Article ID: 287753

Article Last Modified on 2/22/2007

-

APPLIES TO


 * Microsoft Exchange 2000 Server Standard Edition
 * Microsoft SQL Server 2000 Standard Edition

-



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.

Keywords: kbmsg kbprb KB287753

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.