Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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


View products that this article applies to.

This article was previously published under Q287753

↑ Back to the top


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.

↑ Back to the top


Cause

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

↑ Back to the top


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.

↑ Back to the top


Status

This behavior is by design.

↑ Back to the top


Keywords: KB287753, kbprb, kbmsg

↑ Back to the top

Article Info
Article ID : 287753
Revision : 8
Created on : 2/22/2007
Published on : 2/22/2007
Exists online : False
Views : 300