Question: how to import excel data to sql server using 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.