Querying SSISDB for parent-child relations RRS feed

  • Question

  • Hello, I want to query some things out of the SSISDB. After trying I found out the most of the things I was looking for. But one question that is still not answered is:

    How can I find the relationships between packages? I want to see that Package X is started by Parent C, whitch is the child of Parent B and so on... If I can make this visible it will also be possible to see the total jobtime and so on with the execution time of an underlying package.

    Does anybody have the answer? Or is it just not possible?

    Wednesday, September 9, 2015 11:27 AM


  • I recall this question being asked a while ago and the reply was there is no way to find the parent - child relationship.

    Not sure if such MS Connect items exists already, but I would say it could be helpful info.




    Wednesday, September 9, 2015 1:51 PM