Using SQL Server Management Studio to execute an SSIS package

In this recipe, you are going to use SQL Server Management Studio (SSMS) to prepare, and invoke, the execution of an SSIS package deployed to the SSISDB catalog.

Getting ready

Even if you have successfully completed the exercises in Chapter 2, What Is New in SSIS 2016, follow these steps to create an SSIS environment, and configure the CustomLogging project:

1. In SSMS, open the Chapter06_Configuration.sql script located in the C:\SSIS2016Cookbook\Chapter06\Scripts folder.
2. Carefully review the script, and then execute it. The script will create the Chapter06 environment with a single environment variable, and associate it with the CustomLogging project. The cmgr_TestCustomLogging_CS...