Post reply

Duplicate column name resolution - Error on execution

  • September 21, 2005 at 11:27 pm

    #76425

    I am new to DTS, and was using it to import data from one database (3 tables) to another database (1 table).

    I just used the standard Transform Data Task initially, and mapped the columns and got the following error:

    "Duplicate column name resolution could not be done because the ordinal specified a column of a different name"

    I thought this would be because I had in the source, 2 columns(from diff tables) with the same name. So, later on in the select query for the source, i made sure that the one table didnt include that column.

    But i still get this error. Would anyone know how to deal with this error, and whether I have understood it fully?

    Thanks

  • September 22, 2005 at 2:36 am

    #592114

    Suggest you modify your queries to remove any likelihood of ambiguity between column names.  Do this by prefixing the column name with the table name:

    select tablename.columnname from tablename

    If the table names are long, think about using aliases for clarity and speed of typing:

    select t1.columnname from tablename t1

    Regards

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • September 22, 2005 at 9:52 pm

    #592462

    I managed to get the source columns all unique. Still get the error.

    Got no clue what else could be the matter..!!!!

    Any clue as to what else could cause this ?

  • September 23, 2005 at 2:45 am

    #592517

    I've never seen this message before - you've got something strange happening there!  All I can suggest is that you remove transformations one at a time and keep trying ... eventually you will remove the one that's causing the problems and that should allow you to work out why the error is appearing.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply