dynamic columns mapping

• scuby.me

  Mr or Mrs. 500

  Points: 587

  More actions

  June 27, 2014 at 8:36 am

  #296107

  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 🙂

• Phil Parkin

  SSC Guru

  Points: 246978

  More actions

  June 27, 2014 at 8:49 am

  #1725470

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

  The absence of evidence is not evidence of absence.
  Martin Rees

  You can lead a horse to water, but a pencil must be lead.
  Stan Laurel