I've always wondered why DTS packages were sorted by anything other than name, but it took 7 years for me to get frustrated enough to actually do something about it... and when I did, it took only minutes to come up with a solution.
After figuring out that the list was being returned by the system stored proc msdb.dbo.sp_enum_dtspackages, I altered it to sort by name. It works like a charm!
The odd thing is, now SQL Server sees msdb.dbo.sp_enum_dtspackages as a user stored proc (still with owner dbo, though). Have I done something terribly wrong, or is this not an issue?
Thanks,
Brandon McKinney