Don, I am not sure I understand the Question but does this help?
-- ===================================================
PRINT ''
PRINT ''
PRINT ''
PRINT '+-----------------------------------------------------------------------------+'
PRINT '¦ DTS Package Details'
PRINT '+-----------------------------------------------------------------------------+'
PRINT ''
-- ===================================================================================
-- ===[ DTS Package Details ]=========================================================
--
-- Purpose : Lists in Detail DTS Package Names, IDs, Decriptions and Creation Dates
--
-- ===================================================================================
SET NOCOUNT ON
BEGIN
CREATE TABLE #DTS_Packages
(
[Package Name] VARCHAR(60) NOT NULL,
[Package ID] VARCHAR(40) NOT NULL,
[Description] VARCHAR(100) NOT NULL,
[LastDate] DATETIME,
[Owner] VARCHAR(60)
)
INSERT #DTS_Packages
SELECT name, id, description, MAX(createdate) AS LastDate, owner
FROM msdb..sysdtspackages
GROUP BY name, id, description, owner
SELECT [Package Name], [Package ID], [Description], [LastDate], [Owner] FROM #DTS_Packages
DROP TABLE #DTS_Packages
END
SET NOCOUNT OFF
GO
Hope so