Microsoft KB Archive/198141

= BUG: DTS: Two or More Columns with the Same Name Cannot Transfer =

Article ID: 198141

Article Last Modified on 3/14/2005

-

APPLIES TO


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

-



This article was previously published under Q198141



BUG #: 50557 (SQLBUG_70)



SYMPTOMS
When using Data Transformation Services (DTS) to transfer columns with the same name, the transformation fails. For example, using the following query to transfer data from the pubs database with two or more columns named "city" will prevent the DTS engine from successful execution:

SELECT a.city, s2.city, s3.city FROM authors a, authors s2, authors s3



CAUSE
DTS Manager is trying to create columns with the same, non-unique name in the destination table.



WORKAROUND
To work around this problem, give aliases to the columns in the query. For example, the query in the SYMPTOMS section could look like the following:

SELECT a.city AS city1, s2.city AS city2, s3.city AS city3 FROM authors a, authors s2, authors s3



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

Additional query words: col cols

Keywords: kbbug kbpending KB198141

-

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

© Microsoft Corporation. All rights reserved.