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 variable will allow you to configure the connection manager used by the project.

How to do it...

1. Start SSMS, unless it is already running, and make sure that the Object Explorer is connected to the local SQL Server instance on your machine.
2. In the Object...