catalog.deploy_project(SSISDB 数据库)catalog.deploy_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 目录中的文件夹,或更新以前部署的现有项目。Deploys a project to a folder in the Integration ServicesIntegration Services catalog or updates an existing project that has been deployed previously.


catalog.deploy_project [@folder_name =] folder_name   
      , [@project_name =] project_name   
      , [@project_stream =] projectstream   
    [ , [@operation_id ] = operation_id OUTPUT ]   


[@folder_name =] folder_name[@folder_name =] folder_name
在其中部署项目的文件夹的名称。The name of the folder where the project is deployed. folder_namenvarchar(128)The folder_name is nvarchar(128).

[@project_name =] project_name[@project_name =] project_name
文件夹中新的或更新的项目的名称。The name of the new or updated project in the folder. project_namenvarchar(128)The project_name is nvarchar(128).

[@projectstream =] projectstream[@projectstream =] projectstream
Integration ServicesIntegration Services 项目部署文件(扩展名为.ispac)的二进制内容。The binary contents of an Integration ServicesIntegration Services project deployment file (.ispac extension).

您可以使用带 OPENROWSET 函数的 SELECT 语句以及大容量行集提供程序来检索该文件的二进制内容。You can use a SELECT statement with the OPENROWSET function and the BULK rowset provider to retrieve the binary contents of the file. 有关示例,请参阅部署 Integration Services (SSIS) 项目和包For an example, see Deploy Integration Services (SSIS) Projects and Packages. 有关 OPENROWSET 的详细信息,请参阅 OPENROWSET (Transact-SQL)For more information about OPENROWSET, see OPENROWSET (Transact-SQL).

projectstream 为 varbinary(MAX)The projectstream is varbinary(MAX)

[@operation_id =] operation_id[@operation_id =] operation_id
返回部署操作的唯一标识符。Returns the unique identifier for the deployment operation. operation_id 为 bigint。The operation_id is bigint.

返回代码值Return Code Value

0(成功)0 (success)

结果集Result Sets



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

  • 对文件夹具有 CREATE_OBJECTS 权限才能部署新项目;对项目具有 MODIFY 权限才能更新项目CREATE_OBJECTS permissions on the folder to deploy a new project or MODIFY permissions on the project to update a 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 cause this stored procedure to raise an error:

  • 参数引用的对象不存在,参数试图创建的对象已存在,或者参数在某个其他方面无效A parameter refers to an object that does not exist, a parameter tries to create an object that already exists, or a parameter is invalid in some other way

  • 参数 @project_name 的值与部署文件中的项目的名称不匹配。The value of the parameter *@project_name* does not match the name of the project in the deployment file

  • 用户不具备足够的权限The user does not have sufficient permissions


在项目部署或更新期间,存储过程不检查项目中各个包的保护级别。During a project deployment or update, the stored procedure does not check the protection level of individual packages in the project.