Viewing 2 posts - 1 through 2 (of 2 total)
DTS packages are stored in the msdb.dbo.sysdtspackages table.
All you need is to backup that table.
As an alternative you can save DTS as files, but you have to do it manually.
For...
August 13, 2002 at 12:51 am
#434472
SELECT [fieldName], COUNT([fieldName]) AS nDup
FROM [tableName]
GROUP BY [fieldName]
HAVING (COUNT([fieldName] > 1)
August 8, 2002 at 10:12 am
#434283