O'Reilly logo

SQL Server 2017 Integration Services Cookbook by Dejan Sarka, Matija Lah, Christian Cote

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required