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.
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.