Article ID: 315994 - Last Review: October 30, 2003 - Revision: 3.2

BUG: DTS Wizard Generates Unspecified Error Message If Database with a Period in Name is Used

View products that this article applies to.

System TipThis article applies to a different operating system than the one you are using. Article content that may not be relevant to you is disabled.

This article was previously published under Q315994

BUG #: 353691 (SHILOH_BUGS)
BUG #: 102219 (SQLBUG_70)

Expand all | Collapse all

SYMPTOMS

If you run the Data Transformation Services (DTS) Wizard and you specify a database that contains a period in the name as either the source or destination, the following error message appear:

Error Source: Microsoft OLE DB Provider for SQL Server

Error Description: Unspecified Error Could not find server '%1%' in sysservers. Execute sp_addlinkedserver to add the server to sysservers.

Context: Error calling GetRowset to get Schema info. Your provider does not support all the interfaces/methods required by DTS.

The sever name reported in the error message is the first part of the database name. For example, if the database name is DTS.test, the server name that appears in the error message is "DTS".

The error message occurs after you click Copy table(s) from the source database. If you choose the database as the source, after you acknowledge the error message, the DTS Wizard does not display any tables for the list of tables to copy.

The error message may also appear if you select Use a query to specify the data to transfer, and then click Query Builder.

Back to the top