Parameterise SSIS Target Database with SSIS DB

Parameterise SSIS Target Database with SSIS DB

Easily Switch Target Database When Executing SSIS Package with Integration Services Catalog

Best practice for deploying SSIS projects is now to deploy the entire project to the Integration Services Catalog (SSIS DB Catalog), from where executions can be scheduled (!) from SQL Server Agent directly, without the need to call the dtexec utility.

Read Full Blog