SSIS - Excel - extract column names

• PowerUser

  Mr or Mrs. 500

  Points: 553

  More actions

  July 6, 2011 at 12:17 am

  #243496

  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

• Koen Verbeeck

  SSC Guru

  Points: 259165

  More actions

  July 11, 2011 at 3:01 am

  #1350939

  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