How Many sysdtspackages Versions Are Retained?

[Skittle]

Yesterday I discovered that packages are stored in the msdb.sysdtspackages table. I had a look inside was surprised that one of my packges that has been edited many times over the years only has a few versions in the table.

How does SQL Server decide how many versions of a package to retain? Is there a purge function or a date based auto clean up?




Dazed and confused
(N+, MCAD)

 

[gradley]

I don't believe there is a limitation (unless you run out of disk space). It obviously saves a new version everytime you hit the save button. What we sometimes do when we don't want to keep history is while the package is open, select the Window menu option, select the open packages window (usually labeled 1) and then delete the package from the local sql server. Then you can save the open version.

You can also remove them by right-clicking on the package from DTS Local Packages window, selecting versions and deleting everything but the latest version.

 

[mrdenny]

By default it should save all the versions. Right click on the package from the Local Packages window and select versions. They should all be in there.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)