Post reply

Multiple Source to Multiple Destination package

  • September 21, 2012 at 2:19 pm

    #281992

    Hi Guys,

    Thanks for advance,I have one requirement like multiple source to mutiple destination in same package.

    Requirement description :

    1. I am having database name (VLEDB3PRT1) mutiple tables like(User,group,Group access tables)

    2. i wanted transfer the data other db server (VLEDB8PRT1) same for of the source with keys

    we are right now using every table have separt packages,Please let me know how to combine all together.

    Thanks

  • September 21, 2012 at 3:55 pm

    #1541002

    You can have a single Data Flow copy multiple tables.

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

  • September 23, 2012 at 8:12 pm

    #1541254

    The standard SSIS Data Flow Task requires statically defined metadata and therefore requires setup of separate data flow for each source -> destination combination. If you can use third-party solutions check the commercial COZYROC Data Flow Task Plus. It is an extension of the standard Data Flow Task and supports dynamic metadata at runtime. No programming skills are required. You can implement the processing of all your sources and destination with only one Data Flow Task Plus running inside For Each Loop container.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

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

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