Microsoft KB Archive/315994

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

Article ID: 315994

Article Last Modified on 10/30/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition
 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q315994



BUG #: 353691 (SHILOH_BUGS)

BUG #: 102219 (SQLBUG_70)



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 &quot;DTS&quot;.

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.



CAUSE
The period in the database name causes SQL Server to parse the database name incorrectly.



WORKAROUND
To work around this problem, rename the database and remove the period in the database name.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Keywords: kbbug kbpending KB315994

-

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

© Microsoft Corporation. All rights reserved.