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.