Sql server 2008R2 - SSIS importing excel file

See more:

SQL

MS-Excel

server

SSIS

BIDS

I'm starting with a file that:

0) Contains one or more sheets

1) The names of the sheets are not guaranteed to be the same, but the columns in them are always the same

2) The header row is row #5 (and there is data above this row that I don't want to import).

Essentially, I need to import all of the sheets, starting the import at row 5.

Has anyone got any tips?

What I have tried:

I've made a couple of runs at this with googled info, but the process always falls down because they make assumptions that don't apply to my situation.