Export (0) Print
Expand All


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).

Sets the value of a property for an instance of execution in the Integration Services catalog.

set_execution_property_override_value [ @execution_id = execution_id
    , [ @property_path = ] property_path
    , [ @property_value = ] property_value
    , [ @sensitive = ] sensitive

[ @execution_id = ] execution_id

The unique identifier for the instance of execution. The execution_id is bigint.

[ @property_path = ] property_path

The path to the property in the package. The property_path is nvarchar(4000).

[ @property_value = ] property_value

The override value to assign to the property. The property_value is nvarchar(max).

[ @sensitive = ] sensitive

When the value is 1, the property is sensitive and is encrypted when it is stored. When the value is 0, the property is not sensitive and the value is stored in plaintext. The sensitive argument is bit.

This procedure performs the same function as the Property overrides section in the Advanced tab of the Execute Package dialog. The path to the property is derived from the Package Path property of the package task.

The following list describes some conditions that may raise an error or warning:

  • The user does not have the appropriate permissions

  • The execution identifier is not valid

  • The property path is not valid

  • The data type of the property value does not match the data type of the property

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft