Dynamic Column Mapping SSIS

• sqlbi.vvamsi

  Ten Centuries

  Points: 1194

  More actions

  May 11, 2012 at 9:35 am

  #257871

  I've a DB with multiple tables. A SSIS Package to be developed to move table data from src server to destination server.

  I'm using script component as source and destination. How to create output columns in src dynamically like an array of output columns, rather than defining them beforehand.

  Note: Pls don't suggest workarounds. I can do this using Import Export wizard/ Execute SQL Task.

  Thanks.

• Orlando Colamatteo

  SSC Guru

  Points: 182293

  More actions

  May 11, 2012 at 10:28 am

  #1486446

  In general SSIS metadata is meant to be static once it is built. Changing that on the fly is an advance topic, at least. Good luck! Dynamically Map Column Data Based on Column Pattern Profiling[/url]

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato