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

  • December 19, 2013 at 12:00 am

    #1674710

    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.

    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.