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

• Bill Nicolich

  SSCommitted

  Points: 1865

  More actions

  November 18, 2011 at 12:23 pm

  #146629

  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

• Koen Verbeeck

  SSC Guru

  Points: 259115

  More actions

  November 22, 2011 at 3:09 am

  #1411291

  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

• Elliott Whitlow

  SSC Guru

  Points: 102402

  More actions

  November 22, 2011 at 8:48 am

  #1411601

  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