April 11, 2007 at 7:18 am
I have a development server where the sysdtspackages table is now 248MB big, due to a large no. of dts packages and versions of each. Do microsoft supply a system stored procedure to archive old versions from this table, a trawl through msdb did not produce an obvious candidate.
does anyone have such a script or an opinion on deleting rows from this table, it seems a strange design that it add rows every time a dts package is saved so the table grows ad infinitum, but there is no archive process.
---------------------------------------------------------------------
April 11, 2007 at 9:54 am
George,
There's a script posted on this site which purports to delete old package versions. I haven't tried it, but I respect the author's knowledge of SQL Server. Find it here: http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=606
Greg
Greg
April 12, 2007 at 5:04 am
greg, thanks for that. The script also pointed me towards sp_drop_dtspackage in msdb which can beused to drop specific versions of a package, but you have to give it versionid.
george
---------------------------------------------------------------------
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply