question

Fatherjack avatar image
Fatherjack 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`?
sql-server-2008ssisadministration
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Valentino Vranken avatar image
Valentino Vranken answered
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/
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Ah! Thanks. Had to use SSMS 2008, the Database/Integration Services drop down is disabled on my SSMS 2012. Thanks
0 Likes 0 ·
That's weird? Well, glad I could help you out anyway :)
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.