catalog.restore_project
TOC
Collapse the table of content
Expand the table of content

catalog.restore_project (SSISDB Database)

 

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2012)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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.

0 (success)

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.

System_CAPS_ICON_warning.jpg Warning


Environment references may no longer be valid after a project has been restored.

Community Additions

ADD
Show:
© 2016 Microsoft