Loading dimensional data from Excel

So I've got all this Excel data and I need to load a dimension table. What I really need is the distinct list of dimensional keys and values and then do the lookup, but the Excel data source only lets me pick the entire worksheet, so I would have to stage it first....WRONG!!!!!

You can write queries as sources against Excel! Set up your Select Distinct statement and you are ready to go. If you want the easy way to see it done, use the Import/Export wizard in the BI studio and when they ask you about the source, choose the query option.

Just makin' life easier...

Scott Barrett