Any help one this homework? excel sheet with multiple tabs and stored procedure as source

See more:

SQL

SSIS

T-SQL

SQL-Server-2008R2

, +

Create a basic SSIS Package to enter the files provided in “ETL_Diagram Section Files” to a

new Database called Curriculum. The SQL Script will be executed within SSIS in a SQL Task (The script

may be too big to use in a SQL Task. In that case, find another alternative such as putting the script

inside a Stored Procedure.) The Excel file will be loaded within SSIS as well. The end result will be 6

tables loaded to the new Database.

........I am not sure how I to create the remaining 3 tables using a script.. not familiar with stored procedure..Any help?

.......The Excel sheets have different table structures (multiple tabs).


Thank you