Remove old DTS Package versions

,

This Procedure is what I use to clean out all the old DTS package version on my server periodically. You just place it in the msdb database and run it as you need to.

Note: Although I have never had an issue with it, I do suggest backup msdb database beforehand, just in case you wack a version and realize later you didn't want to do it.

CREATE PROCEDURE ip_RemoveOldDTSVersions
AS

-- SET NOCOUNT ON -- I like to know how many items removed.
delete 
sysdtspackages
where
versionid in (
select 
versionid 
from 
sysdtspackages
inner join
(
select 
[id] mxid, 
max(createdate) as mxcd 
from 
sysdtspackages 
group by 
[id]
) as MaxCD
on
[id] = mxid and
createdate != mxcd
)go

Rate

5 (1)

Share

Share

Rate

5 (1)