BUG: DTS Wizard Generates Unspecified Error Message If Database with a Period in Name is Used (315994)
The information in this article applies to:
- Microsoft SQL Server 2000 (all editions)
- Microsoft SQL Server 7.0
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 "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.
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.
STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
| Modification Type: | Major | Last Reviewed: | 10/30/2003 |
|---|
| Keywords: | kbbug kbpending KB315994 |
|---|
|