CODEWITHSUNDEEP
sqldts

Reputation:

Remove DTS packages from SQL Server?

What is the easiest way to remove multiple DTS packages from SQL Server 2008?

Thanks.

Upvotes: 0

Views: 5105

Answers (1)

Ed Harper
Ed Harper

Reputation: 21505

If you're using DTS (not SSIS) the packages are stored on the SQL server, the fastest way to remove them is to delete them directly from where they are held - msdb.dbo.sysdtspackages.

Sysdtspackages contains multiple versions of each package which has been edited and saved.

SELECT *
FROM msdb.dbo.sysdtspackages

will show you the contents of the table.

DELETE 
FROM msdb.dbo.sysdtspackages
WHERE name in ('package1','package2',etc)

will remove the packages you name.

Upvotes: 2

Related Questions