Any suggestions? Export (0) Print
Expand All

catalog.restore_project (SSISDB Database)


Applies To: SQL Server 2014, SQL Server 2016 Preview

Restores a project in the Integration Services catalog to a previous version.

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

[ @folder_name = ] folder_name

The name of the folder that contains the project. The folder_name is nvarchar(128).

[ @project _name = ] project_name

The name of the project. The project_name is nvarchar(128).

[ @object_version_lsn = ] object_version_lsn

The version of the project. The object_version_lsn is bigint.

Project details are returned as varbinary(MAX) as part of the result set if the project_name is found.

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 and MODIFY permissions on the project

  • Membership to the ssis_admin database role

  • Membership to the sysadmin server role

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. 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.

Community Additions

© 2016 Microsoft