BUG: DTS: Two or More Columns with the Same Name Cannot Transfer (198141)

The information in this article applies to:

Microsoft SQL Server 7.0
Microsoft SQL Server 2000 (all editions)

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.

Modification Type:	Minor	Last Reviewed:	3/14/2005
Keywords:	kbBug kbpending KB198141