Is it possible to delete a package within SSIS Catalog?

sql-server ssis ssis-2016
MagnusTheStrong picture MagnusTheStrong · Oct 31, 2016 · Viewed 7.5k times · Source

Seems it could not be done in SSMS. Does Microsoft actually provide this option for users to delete single package within SSIS catalog? Thanks.

Best Regards, Mike

Answer

p2k picture p2k · Oct 31, 2016

Microsoft has added Incremental package deployment in SQL 2016 - This feature lets you deploy one or more packages to an existing or new project without deploying the whole project.

As Incremental package deployment has been added, I believe, decremental for single package is not there. There are no any SPs other than catalog.delete_project, Folder and Environments in SSIS catalog (Projects and Packages).

Related questions

Run SSIS Package Without SQL Server Integration Services

Can we run SSIS Package without integration services? If Yes then what are the steps? If No then what is the minimum requirement. The problem statement is as follow: I am using SQL Azure database to store the data. I …

Read More
SSIS Failed to acquire connection. Connection may not be configured correctly or you may not have the right permissions on this connection

I'm using MS SQL Server 2016. I have a SSIS package, with one execute SQL task. I can execute it fine with Visual Studio. When I deploy to the SSIS Catalog, I receive the below error: Execute SQL Task: Error: Failed …

Read More
querying ssisdb to find the name of packages

i was querying the ssis catlog to find out the name of all the packages in the catalog. There are only 6 packages in the Folder1 project,but the query gives 9 records 1. SELECT P.NAME FROM SSISDB.internal.projects PRJ INNER …

Read More