• OK. I asked because it is easier in SQL Server 2012.

    When the packages are stored in MSDB, they are stored as XML in a table.

    This means you can query the packages using XML methods in TSQL.

    This article might be a good start:

    Collecting information about your SSIS packages

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