how to split excel workbook into individual sheets using SSIS 2008 without using  " Microsoft.Office.Interop.Excel"

The Workbook need to be broken into multiple sheets available in the workbook.

the SSIS package will read the excel workbook and split into individual sheet  and rename the sheet with the name available in the workbook..

You can execute SQL statements against Excel like it were a database.

I found online an example by the way that shows how to create worksheets in Excel dynamically:

http://www.bidn.com/blogs/KeithHyer/bidn-blog/2512/creating-excel-worksheets-dynamically-in-ssis

You can reference the worksheets as if they were tables.

If you want to add sheets, use a create table statement.

Well, I think you got the exact answer to the question you asked.  If you want to do the same, using only VBA, please see this.

http://www.rondebruin.nl/win/s3/win006.htm

See a method here

In your case source will also be excel

http://visakhm.blogspot.ae/2013/09/exporting-sqlserver-data-to-multiple.html