Can a child Package stored on the file system be used simultaneously?

  • Does anyone know off the top of their heads if a child package that is stored on the file system can be used concurrently by multiple packages?

    I want to create a set of packages that can be utilized as a child package of many packages. I've done this before - but with packages stored in SQL Server. Those could be called by multiple parent packages and run at the same time. I'm not sure off the top if the same can be done if they are stored on the file system.

    I thought I'd check here first before going out and setting up a test.

    Thank you!

    Bill.

    Bill Nicolich: www.SQLFave.com.
    Daily tweet of what's new and interesting: AppendNow

  • Did you already test it out? I'm quite curious for the result 🙂

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Yes, it can be used by multiple parents.

    Please see:

    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