How to Delete SSIS Packages From the Server

Remove a SQL Server package from your file system.

SQL Server Integration Services, or SSIS, is a platform for building enterprise-level data integration and data transformation solutions. SSIS packages can help a database administrator copy or download files, send email messages, update data warehouses and manage SQL Server objects. Deleting SSIS from a server can be accomplished easily by using the "dtutil" utility. This command prompt utility can be used to copy, move, delete or verify the existence of a package.

Instructions

1. Open a command prompt window and type the following to delete an SSIS package that is stored in the "msdb" database on an instance of SQL Server that uses "Windows Authentication":

   dtutil /SQL delPackage /DELETE

2. Type the following to delete an SSIS package that is stored in the "msdb" database on an instance of SQL Server that uses "SQL Server Authentication":

   dtutil /SQL delPackage /SOURCEUSER srcUserName /SOURCEPASSWORD #8nGs*w7F /DELETE

3. Type the following to delete a package stored in the SSIS Package Store:

   dtutil /DTS delPackage.dtsx /DELETE

4. Type the following to delete an SSIS package stored in the file system:

   dtutil /FILE c:\delPackage.dtsx /DELETE

References

• MSDN: SQL Server Integration Services
• MSDN: dtutil Utility (SSIS Tool)