Excel file has two tabs(Mon1 and Mon2) and i have loaded them into table by creating SSIS package.
All the tabs have same column names and loaded into single table
Next month, the excel file will have an addtional tab(Mon3) and need to load only the additonal tab(Mon3). Same way for the following months.
Is there any way to load only the additional tab in SSIS?
Otherwise we need to load all the tabs including the additonal tab.