SQL Server Questionwhat table would give me all the DTS packages that use a specific table?

Answer 1

I do not have SQL 2000 installed anymore, so I cannot look up the exact table and column names. However, I can point you in the right direction: Look at the following stored procedures in the MSDB database:

sp_add_dtspackage
sp_enum_dtspackages
sp_get_dtspackage

The commands in these sprocs should give you enough info to find out which system tables store the data you are looking for.