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
