Question: how to import data from excel to table in ssis?
Answer: How to Run Import-Export Wizard., Choose a Data Source as Excel 2003/Excel 2007/CSV., Choose a Destination as SQL Server/SQL Azure., Specify Table Copy or Query., Select Source Tables and Views., Save and Run Package., Complete the Wizard.