Import Data Using SSIS from an Excel Workbook which has Dynamic Sheets Using SSIS invoke-sqlcmd Not Recognized ORDER BY behavior with NOLOCK Automate Generate Scripts in SSMS Invoke-Sqlcmd vs sqlcmd utility Change Select Top 1000 Rows value in SSMS Change The SQL Server Port Number Change Edit Top 200 Rows value in SSMS Decode COLUMNS_UPDATED [...]

Importing data from Excel is a simple task if you are using SSIS. You can accomplish this by simply drag and dropping few controls and you are done. But what if your excel workbook has dynamic sheets, which means you will not know the sheet name. Excel Sheet Let us assume we need to import [...]