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