How to Use SSIS to Import Excel Data that has been Normalized?

Good Morning All,

I was asked if it was possible to take an Excel file, that has already been normalized, and make it the source of my database table.  Columns on the worksheet include fiscal period 1, fiscal period 2....etc.  Rows include general ledger accounts such as Fuel, Mileage, Supplies etc.  The end goal is to create an SSAS cube from this data, after it's been loaded into SQL Server via SSIS.

Can anyone point me to some resources that address a similar situation?

Thanks,

Sid

If you want to import from a SSIS, this is a good resource to start with:

http://www.bidn.com/blogs/kylewalker/ssis/997/setting-up-an-ssis-package-with-a-dymanic-excel-source

If this is a one time load, you can import directly from SSMS:

http://www.bidn.com/blogs/indupriya/bidn-blog/663/importing-excel-2007-data-into-sql-server-2005