catalog.move_project ((SSISDB Database)
Applies To: SQL Server 2014, SQL Server 2016 Preview
Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
Moves a project from one folder to another within the Integration Services catalog.
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.