Menu
I have an SSIS package that I've saved under Maintenance Plans on SQL Server 2005. Though I can select SSIS packages, I am not sure how I can delete them.
450
There are two methods for deleting a package from the SSIS catalog: Use SSDT to remove the package from the SSIS project in the source code, and then redeploy the entire project. Delete the entire project from the SSIS catalog, and redeploy only the desired packages individually (not recommended)
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. The sysssispackages table contains the packages saved to msdb.
Open SQL Server Management Studio. In Object Explorer, expand the Integration Services node, right-click SSISDB, and then click Active Operations. A new window will open with a Stop button where you can cancel a specific operation (a SSIS package that is executing).
John DaCosta's solution worked for me. I wrote the following query to output the deletion commands and pasted the results into a command shell window:
SELECT CONCAT('DTUTIL /SQL "\', f.foldername, '\', name, '" /DELETE /SourceServer MyServerName')
FROM msdb.dbo.sysssispackages s
JOIN msdb.dbo.sysssispackagefolders f
on s.folderid = f.folderid
WHERE ownersid <> 0x01
It sounds like you are trying to delete the package from Database Engine --> Management --> Maintenance Plans. Try connecting to "Integration Services" instead of the Database engine and look for the package you want to delete under Running Packages or Stored Packages.
From there you should be able to right click and delete.
37
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
