When trying to import data from MS Project (.mpp) using DTS, I get 3
consecutive errors.
1. unexpected error occured, the provider has returned an error without an
error message.
2. Context: Error calling get_rowset to get DBSCHEMA_TABLES schema info.
Your Provider does not provide all the schema rowsets required by DTS.
3. unexpected error occured, the provider has returned an error without an
error message.

Process:
The datasource selected is Microsoft Project 10.0 OLE Db provider.
then accessed the properties and selected the all tab. On the All tab,
selected the project name and pressed the edit value button then entered the
path to the .mpp file to be used. then selected OK 2X.

Reselected the properties to Test the connection which succeeds.

Select next to choose destination, selecting the OLE DB provider for sql
server.
the server is Local and the database selected is Northwind with windows
authentication.

Select next and choose copy tables and views from source database.

Select next and the above errors occur.

this seems kind of crazy giving that a provider is available in the dropdown
list of providers.

What can I do, do I have a bad provider for Microsoft project.

thanks in advance for any solutions.