Remove versions of package on SSIS Server

Question

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?

Answer 1

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

Answer 2

Thanks YitzhakKhabinsky-0887 - Much appreciated