catalog.get_project(SSISDB 数据库)catalog.get_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 服务器的项目的二进制流。Retrieves the binary stream of a project that has been deployed to the Integration ServicesIntegration Services server.


catalog.get_project [ @folder_name = ] folder_name , [ @project_name = ] project_name   


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

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

返回代码值Return Code Value

0(成功)0 (success)

结果集Result Sets

该项目的二进制流作为 varbinary(MAX) 返回。The binary stream of the project is returned as varbinary(MAX). 如果找不到文件夹或项目,则不返回任何结果。No results are returned if the folder or project is not found.


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

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

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

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

错误和警告Errors and Warnings

下面的列表描述了一些可能导致 get_project 存储过程引发错误的情况:The following list describes some conditions that may cause the get_project stored procedure to raise an error:

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

  • 文件夹不存在The folder does not exist

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