/* SQL 2005 */
SELECT T1.* 
	FROM dbo.sysdtspackages90 AS T1
		INNER JOIN (
				SELECT [id], MAX([verbuild]) AS [verbuild] 
					FROM dbo.sysdtspackages90 
					GROUP BY [id]) AS T2
			ON T1.[id] = T2.[id] 
			AND T1.[verbuild] = T2.[verbuild]
			
			
/* sql2008 */
SELECT T1.* 
	FROM dbo.sysssispackages AS T1
		INNER JOIN (
				SELECT [id], MAX([verbuild]) AS [verbuild] 
					FROM dbo.sysssispackages 
					GROUP BY [id]) AS T2
			ON T1.[id] = T2.[id] 
			AND T1.[verbuild] = T2.[verbuild]
			
			
/*Extract to File System SQL 2005*/
select 'dtutil /SQL "' +[p].[name] + '" /COPY FILE;"c:\myTestPackages\'+[p].[name]+'.dtsx"' 
from msdb.dbo.sysdtspackages90 [p]

Insert into sysdtspackages (name,id,versionid,description,categoryid,createdate,owner,packagedata,owner_sid,packagetype)
	Select name,id,versionid,description,categoryid,createdate,owner,packagedata,owner_sid,packagetype
		From DTSPackageTransfer
		Where Description <> ''