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

适用范围:SQL Server,包括 Linux Azure SQL 数据库yesAzure SQL 数据仓库no并行数据仓库 APPLIES TO: yesSQL Server, including on Linux yesAzure SQL Database yesAzure SQL Data Warehouse noParallel Data Warehouse

适用对象: yesSQL ServeryesAzure SQL 数据库noAzure SQL 数据仓库no并行数据仓库APPLIES TO: yesSQL Server noAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

Integration ServicesIntegration Services 目录中的项目还原到以前的版本。Restores a project in the Integration ServicesIntegration Services catalog to a previous version.


catalog.restore_project [ @folder_name = ] folder_name  
    , [ @project_name = ] project _name  
    , [ @object_version_lsn = ] object_version_lsn  


[ @folder_name = ] folder_name [ @folder_name = ] folder_name
包含项目的文件夹的名称。The name of the folder that contains the project. folder_namenvarchar(128)The folder_name is nvarchar(128).

[ @project _name = ] project_name [ @project _name = ] project_name
项目的名称。The name of the project. project_namenvarchar(128)The project_name is nvarchar(128).

[ @object_version_lsn = ] object_version_lsn [ @object_version_lsn = ] object_version_lsn
项目的版本。The version of the project. object_version_lsn 为 bigint 。The object_version_lsn is bigint.

返回代码值Return Code Value

0(成功)0 (success)

结果集Result Sets

如果找到 project_name ,则项目详细信息将作为结果的一部分返回为 varbinary(MAX) 。Project details are returned as varbinary(MAX) as part of the result set if the project_name is found.

如果无法将项目还原到指定的文件夹,则返回 NO RESULT SET 。NO RESULT SET is returned if the project cannot be restored to the specified folder.


此存储过程需要下列权限之一:This stored procedure requires one of the following permissions:

  • 针对项目的 READ 和 MODIFY 权限READ and MODIFY permissions on the project

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

  • sysadmin 服务器角色的成员资格Membership to the sysadmin server role

错误和警告Errors and Warnings

下面的列表描述了一些可能引发错误或警告的情况:The following list describes some conditions that may raise an error or warning:

  • 项目版本不存在,或与项目名称不匹配The project version does not exist or does not match the project name

  • 项目不存在。The project does not exist

  • 用户没有相应的权限The user does not have the appropriate permissions


还原某个项目后,将为所有参数分配默认值,并且所有环境引用都保持不变。When a project is restored, all parameters are assigned default values and all environment references remain unchanged. 目录中保留的最大项目版本数量由目录属性 MAX_VERSIONS_PER_PROJECT 决定,如 catalog_property 视图中所示。The maximum number of project versions that are retained in the catalog is determined by the catalog property MAX_VERSIONS_PER_PROJECT, as shown in the catalog_property view.


在还原项目后,环境引用可能不再有效。Environment references may no longer be valid after a project has been restored.