Post reply

Dynamic Column Mapping SSIS

  • 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.

  • 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

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

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