SSIS Nuggets

https://www.sqlservercentral.com/articles/getting-informative-sql-agent-notifications-from-failed-ssis-packages  

https://www.timmitchell.net/post/2016/11/28/a-better-way-to-execute-ssis-packages-with-t-sql/  

catalog.object_parameters https://docs.microsoft.com/en-us/sql/integration-services/system-views/catalog-object-parameters-ssisdb-database https://docs.microsoft.com/en-us/sql/integration-services/system-stored-procedures/catalog-set-object-parameter-value-ssisdb-database catalog.set_execution_parameter_value https://docs.microsoft.com/en-us/sql/integration-services/system-stored-procedures/catalog-set-execution-parameter-value-ssisdb-database