dynamic columns mapping

  • Hi,

    i have ssis package where it imports excel file to sql table that is updated weekly.

    The problem here is the excel columns gets deleted /added sometimes and also the columns gets re-named. So instead of manually mapping the ssis package when ever my excel sheets changes is there any way it can be done automatically.

    please help

    Thanks 🙂

  • Not without a ton of code or the purchase of a third-party add-on.


Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply