SSIS and skipping the first worksheet from excel workbook -
i new ssis , task need accomplish load each worksheet excel workbook except first one.
i managed use script task , foreach container loop through worksheets stumped on how skip first worksheet idea ?
i tried use excellent linq excel provider there seems no nuget ssdt install package , use in script task.
how load excel worksheet 's except first 1 using ssis ?
inside loop, add script task @ beginning of flow. in script task, check name of current sheet , set variable indicates whether sheet want skip or process.
then in precedence constraint script task, check variable see if should continue process or nothing , loop next sheet.
Comments
Post a Comment