Remove versions of package on SSIS Server

Christopher Jack 1,611 Reputation points
2020-12-06T10:07:19.697+00:00

I have had to restore an old version of an SSIS package.

However it is now bottom of the list on the 'Project Versions screen. I am wanting to do some more redeployments however I am wanting to keep it so it is easily restorable and it looks like it is about to drop of the list.

What would be the best way of removing redundant versions from the version list?

45368-test.jpg

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,592 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,784 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,448 questions
0 comments No comments
{count} votes

Accepted answer
  1. Yitzhak Khabinsky 24,836 Reputation points
    2020-12-06T14:43:51.137+00:00

    First of all, SSIS Catalog keeps SSIS project level versions, not the package level.

    (1) It is possible to increase default value (10 by default) of stored versions of SSIS projects. This way you don't need to delete anything. Please see a screen shot below.
    (2) SSIS project versions are housed in the SSISDB database, internal.object_versions table.

    • You can delete SSIS project versions from that table at your own risk.
    • There is a dedicated stored procedure to do exactly that:
      [internal].[cleanup_server_project_version]
      So you can use its source code as a starting point for your needs.

    Just to see it:

    USE SSISDB;  
    GO  
      
    -- to see SSIS projects  
    SELECT * FROM internal.projects;  
      
    -- to see SSIS projects versions  
    SELECT * FROM internal.object_versions;  
    

    Useful link: ssis-catalog-project-versioning

    45502-ssis-catalog-properties.jpg

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Christopher Jack 1,611 Reputation points
    2020-12-06T18:10:53.93+00:00

    Thanks YitzhakKhabinsky-0887 - Much appreciated

    0 comments No comments