SQL and SSIS updating one Table Column for each Excel Sheet

[Pradeep23]

Hi all,

I want to export 1 big excel workbook containing 200 Sheets in it, and is classified according to Class. Each sheet name is unique according to the class.
I am building a package to export data from excel sheet to SQL table. I want to export whole Excel workbook in one table of SQL.
I need help here. I want to add one column Class in the SQL table. I want to add Sheet name into that Class column, so for every sheet if there are 10 items in one sheet. For that 10 items the Class Column will contain that sheet name and as I further exports sheet to that table according to the sheet name the Class column for that particular item should be updated.
Is this possible?

I need idea of how to implement this?

Thank you all in advance.

[ck9663]

I'm not sure you can all do that in SSIS. You might be able to that through T-SQL. You can definitely do that in Excel via VBA...

Good Luck!!!

~~ CK

[Pradeep23]

Thanks Much