Dynamic SSIS Mapping Help

• rocky_498

  SSCertifiable

  Points: 6532

  More actions

  September 8, 2016 at 10:42 pm

  #313209

  Hi Guys,

  I need help and advice. I am thinking to SSIS Template for me to use over and over.

  My destination will always same. However, Source will change time to time. I am thinking is it

  is it possible If I have a table (Destination_Table) and Column should be all destination fields.

  and configure and map the table to insert the row.

  Then read header and mapping read from the table. So next time a new file comes, just configure

  the table and that's it.

  Please advise me, is this possible and how.

  Thank You.

• Phil Parkin

  SSC Guru

  Points: 247141

  More actions

  September 9, 2016 at 4:32 am

  #1899996

  Not possible. Column mapping is a design-time function. There may be 3rd party addons which can help you do this, but they're not free...

  ---