Displays the property override values that were set during execution of the package.
|Column name||Data type||Description|
|property_id||bigint||Unique ID for the property override value.|
|execution_id||bigint||Unique ID for the instance of execution.|
|property_path||nvarchar(4000)||The path to the property in the package.|
|property_value||nvarchar(max)||The override value of the property.|
|sensitive||bit||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.|
This view displays a row for each execution in which property values were overridden using 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.
This view requires one of the following permissions:
READ permission on the instance of execution
Membership to the ssis_admin database role
Membership to the sysadmin server role