Menu
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
400
In SQL Server Data Tools (SSDT), open the Integration Services project that contains the package you want to delete. In Solution Explorer, right-click the package, and then click Delete. Click OK to confirm the deletion or click Cancel to keep the package.
Optionally, you can delete SSISDB logs outside their retention period on a schedule.
There is a way to do that. It is possible to Cancel a running SSIS package via SSISDB's a built-in stored procedure called [catalog]. [stop_operation] .
The default folder is the Packages folder, located in %Program Files%\Microsoft SQL Server\100\DTS. The MSDB folder lists the Integration Services packages that have been saved to the SQL Server msdb database on the server.
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).
132
What I did is this:
I looked for the project_ID from [SSISDB].[internal].[projects]. We have Dev/QA and UAT packages deployed on same server under different projects, which is why I looked for the project_ID.
Then I just ran the delete script on [SSISDB].[internal].[packages]
delete from [SSISDB].[internal].[packages] where project_id=3 and name like '%your package name%'
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
