SQL Server has many functions for reviewing metadata.
The msdb.dbo.sp_enum_dtspackages is one of those functions.
Breaking down the name sp_enum_packages, this is what we get:
- sp ( Stored Procedure )
- enum ( Enumerate )
- dtspackages ( DTS Packages )
It is easy to tell that we can likely use this function to enumerate packages.
The msdb.dbo.sp_enum_dtspackages only works on these versions of SQL Server:
The whole point of doing this post is to draw attention to the risks of using undocumented functions.