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. In SSMS, connect to the SSISDB database; that is, the user database hosting the SSISDB catalog. You can use the following command:
USE SSISDB;
For your convenience, the T-SQL code needed for this chapter is provided in the Chapter06.sql script, located in the C:\SSIS2016Cookbook\Chapter06\Scripts folder.
  1. Use the following query to retrieve the identifier of the environment reference, and assign the value to a variable:
 DECLARE @reference_id INT; SET @reference_id = ( SELECT environment_references.reference_id FROM catalog.folders INNER JOIN catalog.projects ON projects.folder_id = folders.folder_id INNER JOIN catalog.environment_references ON environment_references.project_id = projects.project_id WHERE (folders.name ...

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