catalog.move_project - SSISDB 数据库catalog.move_project - 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 目录中的另一个文件夹。Moves a project from one folder to another within the Integration ServicesIntegration Services catalog.


catalog.move_project [ @source_folder = ] source_folder  
    , [ @project_name = ] project_name  
    , [ @destination_folder = ] destination_folder  


[ @source_folder = ] source_folder[ @source_folder = ] source_folder
此项目在移动之前所在的源文件夹的名称。The name of the source folder, where the project resides before the move. source_foldernvarchar(128)The source_folder is nvarchar(128).

[ @project_name = ] project_name [ @project_name = ] project_name
要移动的项目的名称。The name of the project that is to be moved. project_namenvarchar(128)The project_name is nvarchar(128).

[ @destination_folder = ] destination_folder[ @destination_folder = ] destination_folder
此项目在移动之后所在的目标文件夹的名称。The name of the destionation folder, where the project resides after the move. destination_foldernvarchar(128)The destination_folder is nvarchar(128).

返回代码值Return Code Value

0(成功)0 (success)

结果集Result Sets



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

  • 针对您想移动的项目的 READ 和 MODIFY 权限,以及针对目标文件夹的 CREATE_OBJECTS 权限READ and MODIFY permissions on the project that you want to move and CREATE_OBJECTS permission on the destination folder

  • 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:

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

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

  • 目标文件夹不存在,或目标文件夹已包含具有同名的项目The destination folder does not exist or the destination folder already contains a project with the same name

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


当将项目从源文件夹移到目标文件夹时,将删除源文件夹中的项目和对应的环境引用。When a project is moved from a source folder to a destination folder, the project in the source folder and corresponding environment references are deleted. 在目标文件夹中,将创建相同的项目和环境引用。In the destination folder, an identical project and environment references are created. 在移动之后,相对环境引用将解析为不同的文件夹。Relative environment references will resolve to a different folder after the move. 移动后,绝对引用将解析为同一文件夹。Absolute references will resolve to the same folder after the move.


项目可以具有相对或绝对的环境引用。A project can have relative or absolute environment references. 相对引用通过名称引用环境,这些引用要求环境与项目位于相同文件夹中。Relative references refer to the environment by name, and these references require that the environment reside in the same folder as the project. 绝对引用通过名称和文件夹引用环境,这些引用引用与项目不在同一文件夹中的环境。Absolute references refer to the environment by name and folder, and these references refer to environments that reside in a different folder from that of the project.