catalog.create_environment_reference (SSISDB Database)
Applies To: SQL Server 2014, SQL Server 2016 Preview
Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
Creates an environment reference for a project in the Integration Services catalog.
create_environment_reference [ @folder_name = ] folder_name , [ @project_name = ] project_name , [ @environment_name = ] environment_name , [ @reference_location = ] reference_location [ , [ @environment_folder_name = ] environment_folder_name ] [ , [ @reference_id = ] reference_id OUTPUT ]
The following list describes some conditions that may raise an error or warning:
The folder name is not valid
The project name is not valid
The user does not appropriate permissions
An absolute reference is specified by using the A character in the reference_location parameter, but the name of the folder was not specified with the environment_folder_name parameter.
A project can have relative or absolute environment references. Relative references refer to the environment by name and require that it resides in the same folder as the project. Absolute references refer to the environment by name and folder, and may refer to environments that reside in a different folder than the project. A project can reference multiple environments.