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

  • 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)?