Annie Xu shows us how to validate SSIS packages in the SSISDB catalog using T-SQL:
Recently, I need to do a data warehouse migration for a client. Since there might be some difference between the Dev environment source databases and Prod environment source databases. The migrated SSIS packages for building data warehouse might have some failures because of the changes. So the challenge is how can I validate all my DW packages (100 +) all at once.
Click through for the script.