- In SSMS, connect to the SSISDB database; that is, the user database hosting the SSISDB catalog. You can use the following command:
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.
- 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 ...