catalog.object_parameters(SSISDB 数据库)catalog.object_parameters (SSISDB Database)

适用对象:是SQL Server,包含 Linux 版 是Azure SQL 数据库 是Azure Synapse Analytics (SQL DW) 否并行数据仓库 APPLIES TO: yesSQL Server, including on Linux yesAzure SQL Database yesAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

适用对象: 是SQL Server 否Azure SQL 数据库 否Azure Synapse Analytics (SQL DW) 否并行数据仓库 APPLIES TO: yesSQL Server noAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

显示 Integration ServicesIntegration Services 目录中所有包和项目的参数。Displays the parameters for all packages and projects in the Integration ServicesIntegration Services catalog.

列名Column name 数据类型Data type 描述Description
parameter_idparameter_id bigintbigint 参数的唯一标识符 (ID)。The unique identifier (ID) of the parameter.
project_idproject_id bigintbigint 项目的唯一 ID。The unique ID of the project.
object_typeobject_type smallintsmallint 参数的类型。The type of parameter. 对于项目参数,该值是 20;对于包参数,值是 30The value is 20 for a project parameter and the value is 30 for a package parameter.
object_nameobject_name sysnamesysname 包含对应项目或包的名称。The name of the corresponding project or package.
parameter_nameparameter_name sysname(nvarchar(128))sysname(nvarchar(128)) 参数名。The name of the parameter.
data_typedata_type nvarchar(128)nvarchar(128) 参数的数据类型。The data type of the parameter.
requiredrequired bitbit 如果值为 1,则需要参数值才能开始执行。When the value is 1, the parameter value is required in order to start the execution. 如果值为 0,则不需要参数值即可开始执行。When the value is 0, the parameter value is not required to start the execution.
sensitivesensitive bitbit 当值为 1 时,参数值是敏感的。When the value is 1, the parameter value is sensitive. 当值为 0 时,参数值是不敏感的。When the value is 0, the parameter value is not sensitive.
descriptiondescription nvarchar(1024)nvarchar(1024) 包的可选说明。An optional description of the package.
design_default_valuedesign_default_value sql_variantsql_variant 在设计项目或包的过程中分配的参数的默认值。The default value for the parameter that was assigned during the design of the project or package.
default_valuedefault_value sql_variantsql_variant 服务器上当前使用的默认值。The default value that is currently used on the server.
value_typevalue_type char(1)char(1) 指示参数值的类型。Indicates the type of parameter value. 当 parameter_value 为文本值时,此字段显示 V;当该值通过引用环境对象来分配时,此字段显示 RThis field displays V when parameter_value is a literal value and R when the value is assigned by referencing an environment variable.
value_setvalue_set bitbit 如果值为 1,则已分配参数值。When the value is 1, the parameter value has been assigned. 如果值为 0,则尚未分配参数值。When the value is 0, the parameter value has not been assigned.
referenced_variable_namereferenced_variable_name nvarchar(128)nvarchar(128) 分配给参数值的环境变量的名称。The name of the environment variable that is assigned to the value of the parameter. 默认值为 NULL 。The default value is NULL.
validation_statusvalidation_status char(1)char(1) 标识为仅供参考。Identified for informational purposes only. SQL ServerSQL Server 中不使用。Not used in SQL ServerSQL Server.
last_validation_timelast_validation_time datetimeoffset(7)datetimeoffset(7) 标识为仅供参考。Identified for informational purposes only. SQL ServerSQL Server 中不使用。Not used in SQL ServerSQL Server.

权限Permissions

若要查看此视图中的行,您必须具有以下权限之一:To see rows in this view, you must have one of the following permissions:

  • 针对项目的 READ 权限READ permission on the project

  • ssis_admin 数据库角色的成员资格Membership to the ssis_admin database role

  • sysadmin 服务器角色中的成员资格 。Membership in the sysadmin server role.

将实施行级安全性;只显示您有权查看的行。Row-level security is enforced; only rows that you have permission to view are displayed.