You need to import data from excel file to sql server table, you can do this with a simple import wizard or simple data flow task in SSIS. But there are lots of times which you want to do this data transfer dynamically. Suppose these scenarios: 1- you have many excel files with same structure Read more about Excel to SQL Server, Dynamic Data Flow[…]