Post reply

Master package running multiple concurrent instances of a single generic child package

  • June 12, 2012 at 11:48 am

    #271106

    Is there a way that a master package can call multiple instances of a single child package?

    Here is my situation. I want to do a straight copy of data from tables on one server in one location to another server in another location. There is no data manipulation/transformation going on, just moving data. More or less to create a set of staging talbes.

    I want to build my package so that it can take a table input variable and pull data from the source into the destination. We are just doing full data pulls, not updates.

    So, back to my question. Is there a way to configure the package so that a master package can invoke multiple concurrent instances of the child with each child instance representing a different table?

    Thanks for all help and suggestions.

  • June 12, 2012 at 2:51 pm

    #1500062

    I know for a fact that a master package can instantiate multiple instances of the same child package.

    I guess the tough bit to work out is how to pass the variable from the parent to the child package. Parent variable configurations won't do it as they'll all end up with the same table!

    I recommend instead a job queue table. Simply fill it up in the master package with the list of files to be imported and each of the child packages can take the top one, and mark it as being processed. The select statement which the child packages use will need to only pick files which have not yet been processed.

  • June 14, 2012 at 3:51 pm

    #1501305

    You might look at:

    http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/70346/[/url]

    and:

    http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/70347/[/url]

    CEWII

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

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