• To read range from Excel in SSIS you can refer this:

    SSIS: Read single cell values in excel using RANGE name

    Vikash Kumar Singh || www.singhvikash.in