SSIS - Excel - extract column names

  • Hy everybody,

    is it possible to get the column name from an excel sheet (e.g. in my Sheet are the Columns named test1, test2, test3) and insert the values in a table (sql server 2008)?

    I need the column names as values for a dimension.

    Thanks

  • Sure.

    In the Excel connection manager, change HDR=YES to HDR=NO. This means that the Exel file won't have a header row, so you read the first line as normal data. Use a conditional split to keep only the first line and discard everything else and then write the data to your dimension.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

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

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