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 18, 2013 at 12:01 am

    #1674286

    Koen Verbeeck (12/17/2013)

    I would read the head as it were data and concatenate the values in a script component.

    One question though: why do you need to fiddle around with the header when you are importing to a SQL Server table?

    Koen,

    Thanks for your reply. We are not doing anything with header in the sql table, we just ignore the header part. All we are trying to do is deriving a column with values from different cells.