• What is common between your Excel source and Database Table? Does the column name or sequence of column as you have shown in the example appears as they are in DB table.

    I would suggest you to

    1. Create a Script Task in SSIS and read the excel columns one by one and create a data table out of it.

    2. After that you can compare the columns you have in data table with your Database table and add any new column that does not exist.

    3. After that you can build a dynamic INSERT statement and pass on the column values as parameter.

    If you can share your database table strucuture it might help to provide some solution. At this point the requirement seems incomplete.

    If you do not know how to read Excel columns into SSIS you can refer below link or search on sqlservercentral.com or google it.

    SSIS: How to read Excel Meta Data?

    Vikash Kumar Singh || www.singhvikash.in