Post reply

Creating Union All transform dynamically in SSIS

  • June 1, 2009 at 6:31 am

    #134480

    when there 2 columns with the same name in the flow (from different components)

    the union all complains that the package contains 2 objects with duplicate name.

    Someone knows whats the best way 2 deal with it?

    Thanks ahead

    ERan

  • October 16, 2009 at 6:17 am

    #1066823

    I am having the same problem. Has anyone solved this?

  • October 16, 2009 at 10:58 am

    #1067058

    nmeseth (10/16/2009)

    I am having the same problem. Has anyone solved this?

    You can change the name of the data flow column to be different than the original source column. This will resolve the duplication issue.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  • October 21, 2009 at 5:04 am

    #1068763

    Not just Union All, there are other components that would have the same issue in case of duplicate column names. Its a better practice to keep column names unique as far as possible.

    --Siddharth

  • October 21, 2009 at 5:14 am

    #1068770

    Siddharth Mehta (10/21/2009)

    Not just Union All, there are other components that would have the same issue in case of duplicate column names. Its a better practice to keep column names unique as far as possible.

    --Siddharth

    Like 'ID', for example? Or 'Description'? Or 'State'?

    There are perfectly legitimate reasons for duplicate column names appearing in multi-table queries and qualifying or aliasing such column names to uniquely identify the ones which are required is also fine, IMO.

    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 5 posts - 1 through 4 (of 4 total)

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