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

• Microsoft SQL Server version 7.0

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 this to be a problem in SQL Server version 7.0.

Additional query words: col cols

Keywords : kbbug7.00
Version : WINNT:7.0
Platform : winnt
Issue type : kbbug