ssis - know package wise destination table information using sql query

Question

I have multiple SSIS package and in each package have multiple data flow task. I want to destination table or target table name for each package, for that I want to open each package and each data flow task to check destination table name so it is hard to check each and every package and data flow task . I have required SQL query to fetch below information from the package and as output i have required below column name from the ssis database.

Column to require in the result set

PackageName, DestinationTableName.

Thanks, Nayan.

question from:https://stackoverflow.com/questions/65842635/know-package-wise-destination-table-information-using-sql-query

Answer 1

Waitting for answers