Set Parameter Values After the Project Is Deployed


Applies To: SQL Server 2016

The Deployment Wizard allows you to set server default parameter values when you deploy your project to the catalog. After your project is in the catalog, you can use SQL Server Management Studio (SSMS) Object Explorer or Transact-SQL to set server default values.

To set server defaults with SSMS Object Explorer:

  1. Select and right-click the project under the Integration Services node.

  2. Click Properties to open the Project Properties dialog window.

  3. Open the parameters page by clicking Parameters under Select a page.

  4. Select the desired parameter in the Parameters list. Note: The Container column helps distinguish project parameters from package parameters.

  5. In the Value column, specify the desired server default parameter value.

To set server defaults with Transact-SQL, use the catalog.set_object_parameter_value (SSISDB Database) stored procedure. To view current server defaults, query the catalog.object_parameters (SSISDB Database) view. To clear a server default value, use the catalog.clear_object_parameter_value (SSISDB Database) stored procedure.

Community Additions