Post reply

DTS Execute Package Task - Select Package, sort order random

  • July 20, 2007 at 8:53 pm

    #179722

    Whenever I select the package to execute in the DTS Execute Package Task - Select Package dialog, the sort order of the packages is not in ascending sequence by name. Is there a way to accomplish this sort sequence? I takes a long time to scroll through a long list of package names to find the right one.

    Thanks,

    CJR

  • July 23, 2007 at 12:10 am

    #721430

    You can sort by name. There is a option. Just click the name and it will either sort in ascending order or descending order.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • July 23, 2007 at 5:00 pm

    #721717

    I think what CJR is referring to is the pop-up list of packages you see when you're creating an Execute Package task in DTS Designer.  The packages are ordered by package ID and, as far as I know, there isn't a way to sort them alphabetically in that list.

    Greg

    Greg

  • June 17, 2008 at 3:51 am

    #829656

    This is really annoying.

    The order of package list is defined in msdb..[b]sp_enum_dtspackages[/b].

    So if you have permissions you can modify it.

    In my case, I didn't have such and had to lookup for package id executing [sp_enum_dtspackages] and filtering by name =/

    Still better than stepping thru 500+ packages in random order.

    If anybody knows an easier way, please share.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply