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