Interview Question in Data Transformation Services (DTS)
Interview Question :: SQL Server Questionwhat table would give me all the DTS packages that use a specific table
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.
Loading ...