Post reply

Reordering Columns in output

  • March 29, 2010 at 10:39 am

    #142212

    Hi all,

    There's got to be a simpler way to do this in my SSIS package. Currently, I go into my destination data flow task under mappings, then advanced and delete columnns then click new and put that column in the correct order I want it. This is painstaking when I have alot of columns.

    Is there a quick way to put the columns in the order I want them?

    Thanks,

    Strick

  • March 29, 2010 at 1:20 pm

    #1141664

    Why are you doing this?

    CEWII

  • March 29, 2010 at 3:03 pm

    #1141741

    Hi,

    The output MUST be in a specific order.

    Thanks,

    Strick

  • March 29, 2010 at 3:49 pm

    #1141778

    What destination are you using? The column order is defined be the destination object such as a table or a flat file connection. The mappings are done on the destination task and they DON'T have to be any specific order, the 5th input column in the pipeline can map to the 10th column in the destinaton.

    Perhaps I didn't understand what you where doing.

    CEWII

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

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