Issues in calling the same child package from multiple sources

• david.hao

  SSC-Addicted

  Points: 444

  More actions

  July 15, 2013 at 9:37 am

  #277425

  Hi,

  I have a master package which will call the same child package with different variables. To avoid a variable assignment mess-up, I save the same child package with different names, like ChildPack1, ChildPack2, and ChildPack3 on SSIS server. In this way, when called from master package, I assign variable with different values when calling each child packages. For instance, assign Var in ChildPack1 to "A", Var in ChildPack2 to "B".. Now I noticed I encountered an issue, ChildPack2 and ChildPack3 hang after ChildPack1 is launched. Anyone has encountered the same issue and knows why?

• Phil Parkin

  SSC Guru

  Points: 247180

  More actions

  July 15, 2013 at 11:53 am

  #1632610

  Did you generate new IDs for the child packages, or are they exact copies?

  (I'm not sure whether it matters, but worth checking.)

  ---