How can we find the parent package of a subpackage ?

• ansz5

  Ten Centuries

  Points: 1282

  More actions

  January 2, 2009 at 2:50 am

  #72360

  I have a large dts package which is calling many subpackages which in turn call many other subpackages,

  Is anybody aware of how can we find the which subpackage is called from where ?

  Is there any such option to search the entire package to find a particular subpackage or any system tables which store such info..?

  Pls guide.

  Thanks & regards

  ansz5

• MANU-J.

  SSC-Dedicated

  Points: 31126

  More actions

  January 2, 2009 at 6:01 am

  #920217

  I don't think its possible using sql server native tables. Third party utilities might help here.

  MJ