SSIS Package Deletion

Last Post 22 Feb 2008 12:10 AM by SQLUSA. 3 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
reginab
New Member
New Member

--
21 Feb 2008 01:32 PM
I created several SSIS packages on the server while I was learning SQL Server 2005 and now I'd like to delete. Can someone tell me how to do that. The only way I can see them is when I go into visual studio and select Add Existing Package. I know they are stored in MSDB but what SQL Statement would I use to delete them.
SQLUSA
New Member
New Member

--
22 Feb 2008 12:10 AM
You can use DTUTIL to delete it. It operates as command line.

dtutil Utility Article: http://msdn2.microsoft.com/en-us/li...62820.aspx

Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
SQLUSA: http://www.sqlusa.com/order2005ssis/ The Best SQL Server 2005 Training in the World!
pdherder
New Member
New Member

--
12 Mar 2008 02:30 AM
You can also use SMSS to delete packages. Connect to integration services on the server on which you installed the packages. In the Stored packages section you can see which packages are installed in the msdb.
SQLUSA
New Member
New Member

--
12 Mar 2008 11:12 PM
what is SMSS? SSMS?


Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
BI Workshop NYC - March 17-20: http://www.sqlusa.com/
You are not authorized to post a reply.

Acceptable Use Policy