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
The ExOLEDB Provider is not intended to work with DTS, and does not implement all of the required interfaces.
↑ Back to the top
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