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:
- In SSMS, open the Chapter06_Configuration.sql script located in the C:\SSIS2016Cookbook\Chapter06\Scripts folder.
- 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.