I want to import Excel file to SQL Server through SSIS(BI). while exporting i should select all the sheet(eg: sheet1,sheet2 ) in th excel to the sql server. Please guide me step by step how to do in Control flow and Dataflow...
If you could explain me in sanp shoot it will be much better. In such you can mail me the snap shot to email@example.com
Thanks in advance Jayhar