Home Forums Data Warehousing Integration Services Skip Header Rows in Excel and Concatenate Excel column names in SSIS RE: Skip Header Rows in Excel and Concatenate Excel column names in SSIS

  • chaseurpuli (12/19/2013)


    Phil Parkin (12/19/2013)


    chaseurpuli (12/18/2013)


    Phil Parkin (12/18/2013)


    Phil Parkin (12/18/2013)


    Sounds like you need an asynchronous script component.

    But why do you care what the column name is?

    Thanks for your reply Phil. Unfortunately, the destination table is designed such that the column names should be combination of the names from Row 3 and Row 4.

    You could map a source column called 'chicken' to a destination column called 'squirrel' with no issues at all: column names do not have to match.

    Yes, we can match the source column to whatever destination column, but how do I define the destination column name as an expression (concatenation of two row values)?

    I don't understand.

    Why 'define' the destination column? Surely it already exists? Just map column x to it and forget about this concatenation malarkey.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.