BUG: DTS Designer Does Not Show Columns in Build Query if Database Name is Non ANSI (255041)


The information in this article applies to:

  • Microsoft SQL Server 7.0
This article was previously published under Q255041
BUG #: 57579 (SQLBUG_70)

SYMPTOMS

If you have a database that uses a non-ANSI name convention (for example, a space in its name or a database name that begins with a number), when you use the Data Transformation Services (DTS) Designer to build a query, you will not see any of the individual columns for any of the tables in the database. All you see is "(All Columns)" for each of the tables in that database.

WORKAROUND

Rename the database by using the SP_RENAMEDB stored procedure to eliminate or replace the space(s) in the database name.

STATUS

Microsoft has confirmed this to be a problem in SQL Server 7.0.
Modification Type:MajorLast Reviewed:10/16/2002
Keywords:kbBug KB255041
©2002 Microsoft Corporation. All rights reserved.