asked
How to remove a SSIS package from SQL Server
I have created a SSIS package and saved/deployed it to my server but used the wrong name for the package. This means that the old version and the new version of the package are showing on the server as runnable. How do I remove one of the packages please? Is it a simple `DELETE FROM sys.ssispackages`?
Oh no, it's not a good idea to manipulate the system tables directly! (though it could work) Another (cleaner) approach is to use SSMS. When connecting to an instance using the *Connect* dropdown in the Object Explorer, select **Integration Services**. Enter your SSIS server name (without instance, SSIS is not instance-aware) and connect to it. As you mentioned sys.ssispackages, I'm guessing you've deployed your package to the MSDB? So locate the package under the Stored Packages\\MSDB node, right-click it and select **Delete**. If you're not able to connect to the SSIS instance, another option is using the **msdb.dbo.sp_ssis_deletepackage** system stored proc. I've got some details about that here: [Recursively Delete SSIS Folder][1] [1]:
http://blog.hoegaerden.be/2010/02/28/recursively-delete-ssis-folder/
Ah! Thanks. Had to use SSMS 2008, the Database/Integration Services drop down is disabled on my SSMS 2012. Thanks
9 People are following this question.
