Project Versions Dialog Box


Applies To: SQL Server 2016

Use the Project Versions dialog box to view versions of a project and to restore a previous version.

You can also view previous versions in the catalog.object_versions (SSISDB Database) view, and use the catalog.restore_project (SSISDB Database) stored procedure to restore previous versions.

What do you want to do?

  1. In SQL Server Management Studio, connect to the Integration Services server.

    That is, connect to the instance of the SQL Server Database Engine that hosts the Integration Services database.

  2. In Object Explorer, expand the tree to display the Integration Services Catalogs node.

  3. Expand the Integration Services Catalogs node to display the SSISDB node.

  4. The SSISDB node contains one or more folders that each contain one or more projects. Expand the folder that contains the project you are interested in.

  5. Right-click the project, and then click Versions.

In the Project Versions dialog box, the Versions table displays the list of versions of the project that have been deployed on the server, with the date and time the version was deployed, the date and time the version was restored (if it was restored), the version description, and a version identifier. The currently active version is indicated with a check mark in the Current column of the table.

To restore a previous version of a project, select the version in the Versions table, and then click Restore to Selected Version. The project is restored to the selected version and that version is indicated with a check mark in the Current column of the Versions table.

Community Additions