Right Click on Database in which your table exists or you want to create it and load Excel data as shown below
Choose the Data Source:
Choose a Destination:
Specify a Table Copy or Query:
Select Source Tables and Views:
Save and Run Package:
Save SSIS Package:
Complete the Wizard:Summary of all the steps will be shown to you in this step. You can see the source and destination etc.
The Package is created on desktop as per my given path.