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

How to do it...

  1. Using Windows Explorer, locate the Chapter06_Execution_DTExec.bat command file in the C:\SSIS2016Cookbook\Chapter06\Scripts\ folder.
  2. Right-click the file, and select Edit from the shortcut menu to open the file in Notepad.
  3. Inspect the DTExec command line:
    DTExec /Server localhost /ISServer "\SSISDB\CustomLogging\CustomLogging\CustomLogging.dtsx" /Env 1 /Par $ServerOption::LOGGING_LEVEL(Int32);1

The /Server argument provides the name of the SSIS Server, the /ISServer argument instructs the utility to load the SSIS package from the SSISDB Catalog (the complete path to the package must be provided), the /Env argument provides the environment reference identifier, and the /Par arguments provide a way to supply any other runtime ...

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